Skip to content

Aggregations

An aggregate function performs a calculation on a set of values, and returns a single value. Aggregate functions are often used in where clauses in combination with groupBy.

List of aggregations

Aggregation Description
MIN This aggregation returns the min value of the given field of the set of result entries
MAX This aggregation returns the max value of the given field of the set of result entries
COUNT This aggregations counts the amount of result entries
AVG This aggregation calculates the average amount of the given field
SUM This aggregation sums all field values of the given field

Last update: 2020-12-12