Aggregation Functions

Studio provides several aggregation functions, allowing you to compute characteristics of entire columns. Aggregate expression functions can best be utilized in combination with the Big Number chart, allowing you to display aggregated data to users.

Function
Description
sum(real)Returns the sum of all values in a column.
count(real)Returns count of the values of the column.
mean(real)Returns mean value of the column.
agg_min(real)Returns the min value of the column.
agg_max(real)Returns the max value of the column.
quantile(real, k)Returns the indexes of given k quantiles of the column.

A big number chart displaying the sum of a column.