Specifying How to Aggregate a Measure
Specifying How to Aggregate a Measure
The Aggregate option specifies how to aggregate values for this measure, whenever combining multiple records. If you specify this, use one of the following values:
-
SUM (the default) — Adds the values in the set.
-
COUNT — Counts the records for which the source data has a non-null (and nonzero) value.
-
MAX — Uses the largest value in the set.
-
MIN — Uses the smallest value in the set.
-
AVG — Calculates the average value for the set.
For a boolean or a string measure, select COUNT.