|
Aggregates have some expressions that are specific to location lists. These expressions can help create advanced calculations including: rates, averages, and totals.
The following aggregate statistics can be applied to any aggregate column (i.e. LocationList.<AggregateName>.<AggregateStatistic>)
Aggregate Statistic
|
Description
|
Sum
|
The sum of an aggregate column.
|
Mean
|
The mean of an aggregate column.
|
Variance
|
The average variance of an aggregate column. Shows, on average, how widely distributed the aggregate column is.
|
TotalVariance
|
The total variance of an aggregate column. Shows how widely distributed the aggregate column is.
|
StandardDeviation
|
The standard deviation of an aggregate column.
|
Skew
|
The skew (or first moment) of an aggregate column. Shows data symmetry.
|
Kurtosis
|
The kurtosis (or second moment) of an aggregate column.
|
Moment3
|
The third moment of an aggregate column.
|
Moment4
|
The fourth moment of an aggregate column.
|
MinValue
|
The minimum value of an aggregate column.
|
MaxValue
|
The maximum value of an aggregate column.
|
Pre Stage Functions
Function
|
Description
|
SetActive
|
SetActive(boolean,[IncludeInactive])
SetActive is used to determine which set of locations are active for the stage. The second parameter is optional and tells the function if it should act on locations that are inactive. By default it only acts on active locations.
|
Sort
|
Sort(AggregateName,Desc)
Sort is used to sort the location list before a stage.
|
Top
|
Top(Number)
The top function returns true the location is less than or equal to the number specified. The top function can also act on a percentage when called with a number followed by the "%" symbol.
|
|