Returns the predominant value of an entire column, predominant values per group, the weighted predominant value of an entire column, or weighted predominant values per group.
Syntax
AGGPRD(Column)
AGGPRD(Column, Group)
AGGPRD(Column, , Weight)
AGGPRD(Column, Group, Weight)
ColumnAggregatePrd(Column)
ColumnAggregatePrd(Column, Group)
ColumnAggregatePrd(Column, , Weight)
ColumnAggregatePrd(Column, Group, Weight)
Input
Column | is a column |
Domain type: | any domain |
Group | is the 'group by' column |
Domain type: | any Class, ID, Group or Bool domain |
Weight | is the weight column |
Domain type: | any Value domain |
Output
AGGPRD(Column) or ColumnAggregatePrd(Column) |
|
returns: |
the predominant value of a column |
Domain: |
the domain of the input column |
AGGPRD(Column, Group) or ColumnAggregatePrd(Column, Group) |
|
returns: |
predominant values per group |
Domain: |
the domain of the input column |
AGGPRD(Column, , Weight) or ColumnAggregatePrd(Column, , Weight) |
|
returns: |
weighted predominant value |
Domain: | the domain of the input column |
AGGPRD(Column, Group, Weight) or ColumnAggregatePrd(Column, Group, Weight) |
|
returns: |
weighted predominant values per group |
Domain: | the domain of the input column |
Notes:
Tip:
When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.
Usable in
Examples
TabCalc example:
OutCol1 = AGGPRD(Area)
OutCol2 = AGGPRD(Area,Landuse)
OutCol3 = AGGPRD(Area,,Weights)
OutCol4 = AGGPRD(Area,Landuse,Weights)
Parcel |
Landuse |
Area |
Weights |
OutCol1 |
OutCol2 |
OutCol3 |
OutCol4 |
00123 |
Residential |
4000 |
2 |
3500 |
3500 |
17500 |
4000 |
00124 |
Residential |
3500 |
1 |
3500 |
3500 |
17500 |
4000 |
00125 |
Commercial |
17500 |
4 |
3500 |
17500 |
17500 |
17500 |
00126 |
Residential |
7500 |
1 |
3500 |
3500 |
17500 |
4000 |
00127 |
Industrial |
20000 |
? |
3500 |
20000 |
17500 |
? |
01272 |
Institutional |
12500 |
2 |
3500 |
12500 |
17500 |
12500 |
04625 |
Residential |
5000 |
1 |
3500 |
3500 |
17500 |
4000 |
See also:
AGGMED | |
Aggregate Column (dialog box) |