Use aggregate functions for calculated fields and measures
Aggregate functions in calculated fields perform calculations based on groups of rows, rather than on a single row.
For example, it doesn't make sense to use sum or average on a single value. Instead you may want to take the sum or average over a row or column group or over the total data set.
For those familiar with SQL statements, you can think of aggregate functions in the custom report editor as analogous to a function such as a GROUP BY clause in a SELECT statement.
These are the aggregate functions available:
- Average
- Median
- Range
- WeightedAverage
- CountAll
- Min
- StdDevP
- CountDistinct
- Mode
- Max
- PercentOf
- Sum
Related Content
-
Create a custom report from a standard report
Format:
Article,
1 min read
-
Aggregate functions in calculated fields and measures
Format:
Article,
2 min read