﻿ Expressions

# Expressions

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.