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.

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support