|
Using Aggregations
Monarch Classic includes aggregations which you can use to perform arithmetic functions on the values of a measure in a summary. The following types of aggregations are available in the Edit Measure Expression dialog:
Cumulative aggregations
|
Aggregation |
Description |
|
Cum() |
Returns the cumulative sum. |
|
CumCount(*) |
Returns the cumulative row count. |
|
CumCountPct(*) |
Returns the cumulative row count as a percentage of the total rows. |
|
CumPct() |
Returns the cumulative sum as a percentage of the total sum. |
Count aggregations
|
Aggregation |
Description |
|
Count(*) |
Returns the count of rows (or non-null values of the field) within the group. |
|
CountPct(*) |
Returns the group row count as a percentage of the total rows. |
|
CountSubPct(*) |
Returns the group row count as a percentage of the row count in the next larger group. |
|
CumCount(*) |
Returns the cumulative row count. |
|
CumCountPct(*) |
Returns the cumulative row count as a percentage of the total rows. |
Percentage aggregations
|
Aggregation |
Description |
|
CountPct(*) |
Returns the group row count as a percentage of the total rows. |
|
CountSubPct(*) |
Returns the group row count as a percentage of the row count in the next larger group. |
|
CumCountPct(*) |
Returns the cumulative row count as a percentage of the total rows. |
|
CumPct() |
Returns the cumulative sum as a percentage of the total sum. |
|
Pct() |
Returns the group sum as a percentage of the total sum. |
|
SubPct() |
Returns the group sum as a percentage of the group sum of the next larger group. |
Statistical aggregations
|
Aggregation |
Description |
|
Avg() |
Returns the average value of the field within the group. |
|
Max() |
Returns the maximum value of the field within the group. |
|
Min() |
Returns the minimum value of the field within the group. |
|
Stdev() |
Returns the standard deviation of the field values within the group. |
|
StdevP() |
Returns the standard deviation (with respect to the population) of the field values within the group. |
|
Sum() |
Returns the sum of the field values in the group. |
|
Var() |
Returns the variance of the field values within the group. |
|
VarP() |
Returns the variance (with respect to the population) of the field values within the group. |
Special aggregations
|
Aggregation |
Description |
|
Unique() |
Returns the unique value of the field if there is a unique value, otherwise returns null. |