An aggregate formatter calculates a set of values and returns a single value. For example, the average :aggAvg takes a list of values and returns the average.

The following aggregators are available:

  • aggSum returns the sum of all values in a set.

  • aggAvg returns the average of a set.

  • aggMin returns the minimum value in a set.

  • aggMax returns the maximum value in a set.

  • aggCount returns the number of items in a set.

  • aggCumSum the cumulative sums, also known as running totals, returns the total sum of data as it grows with series.

Aggregators can be printed as standalone expressions or can be part of loops to compute custom grouping clauses, e.g., sub-totals, cumulative totals.

Last updated