Skip to main content

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.

FeedbackOpens in a new tab