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. |