Expressions

Top  Previous  Next

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.