Aggregates

The following functions allow you to fetch aggregated values from datasets in expression bindings.

📄️ groupConcat

Concatenates all of the values in the given column of the given dataset into a string, with each value separated by the string separator.

📄️ max

Finds and returns the maximum value in the given column of the given dataset, or the max value in a series of numbers specified as arguments.

📄️ maxDate

Finds and returns the maximum date in the given column of the given dataset, or the max value in a series of dates specified as arguments.

📄️ mean

Calculates the mean (a.k.a average) for the numbers in the given column of the given dataset or the mean of a series of numbers specified as arguments.

📄️ median

Calculates the median for the numbers in the given column of the given dataset or the median of a series of numbers specified as arguments.

📄️ min

Finds and returns the minimum value in the given column of the given dataset, or the min value in a series of numbers specified as arguments.

📄️ minDate

Finds and returns the minimum date in the given column of the given dataset, or the min value in a series of dates specified as arguments.

📄️ stdDev

Calculates the sample standard deviation of the values in the given column of the given dataset, or the standard deviation for a series of numbers specified as arguments.

📄️ sum

Calculates the sum of the values in the given column of the given dataset, or the sum for a series of numbers specified as arguments.