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