Aggregation functions

Aggregation Functions

Learn how to use aggregation functions to perform calculations on a set of values and return a single value.

arg_max() (aggregation function)

Learn how to use the arg_max() aggregation function to find a row in a table that maximizes the input expression.

arg_min() (aggregation function)

Learn how to use the arg_min() aggregation function to find a row in a table that minimizes the input expression.

avg() (aggregation function)

Learn how to use the avg() function to calculate the average value of an expression.

avgif() (aggregation function)

Learn how to use the avgif() function to return the average value of an expression where the predicate evaluates to true.

binary_all_and() (aggregation function)

Learn how to use the binary_all_and() function to aggregate values using the binary AND operation.

binary_all_or() (aggregation function)

Learn how to use the binary_all_or() function to aggregate values using the binary OR operation.

binary_all_xor() (aggregation function)

Learn how to use the binary_all_xor() function to aggregate values using the binary XOR operation.

buildschema() (aggregation function)

Learn how to use the buildschema() function to build a table schema from a dynamic expression.

count_distinct() (aggregation function) - (preview)

Learn how to use the count_distinct() (aggregation function) to count unique values specified by a scalar expression per summary group.

count_distinctif() (aggregation function) - (preview)

Learn how to use the count_distinctif() function to count unique values of a scalar expression in records for which the predicate evaluates to true.

count() (aggregation function)

Learn how to use the count() function to count the number of records in a group.

countif() (aggregation function)

Learn how to use the countif() function to count the rows where the predicate evaluates to true.

dcount() (aggregation function)

Learn how to use the dcount() function to return an estimate of the number of distinct values of an expression within a group.

dcountif() (aggregation function)

Learn how to use the dcountif() function to return an estimate of the number of distinct values of an expression for rows where the predicate evaluates to true.

hll_if() (aggregation function)

Learn how to use the hll_if() function to calculate the intermediate results of the dcount() function.

hll_merge() (aggregation function)

Learn how to use the hll_merge() function to merge HLL results into a single HLL value.

hll() (aggregation function)

Learn how to use the hll() function to calculate the results of the dcount() function.

make_bag_if() (aggregation function)

Learn how to use the make_bag_if() function to create a dynamic JSON property bag of expression values where the predicate evaluates to true.

make_bag() (aggregation function)

Learn how to use the make_bag() aggregation function to create a dynamic JSON property bag.

make_list_if() (aggregation function)

Learn how to use the make_list_if() aggregation function to create a dynamic JSON object of expression values where the predicate evaluates to true.

make_list_with_nulls() (aggregation function)

Learn how to use the make_list_with_nulls() aggregation function to create a dynamic JSON object (array) which includes null values.

make_list() (aggregation function)

Learn how to use the make_list() function to create a dynamic JSON object array of all the values of the expressions in the group.

make_set_if() (aggregation function)

Learn how to use the make_set_if() function to create a dynamic JSON object of a set of distinct values that an expression takes where the predicate evaluates to true.

make_set() (aggregation function)

Learn how to use the make_set() function to return a JSON array of the distinct values that the expression takes in the group.

max() (aggregation function)

Learn how to use the max() function to find the maximum value of the expression in the table.

maxif() (aggregation function)

Learn how to use the maxif() function to calculate the maximum value of an expression where the predicate evaluates to true.

min() (aggregation function)

Learn how to use the min() function to find the minimum value in a table.

minif() (aggregation function)

Learn how to use the minif() function to return the minimum value of an expression where the predicate evaluates to true.

percentile(), percentiles()

Learn how to use the percentile(), percentiles() functions to calculate estimates for nearest rank percentiles.

percentilew(), percentilesw()

Learn how to use the percentilew(), percentilesw() functions to calculate weighted percentiles.

stdev() (aggregation function)

Learn how to use the stdev() aggregation function to calculate the standard deviation of an expression using Bessel’s correction.

stdevif() (aggregation function)

Learn how to use the stdevif() function to calculate the standard deviation of an expression where the predicate evaluates to true.

stdevp() (aggregation function)

Learn how to use the stdevp() aggregation function to calculate the standard deviation of an expression.

sum() (aggregation function)

Learn how to use the sum() (aggregation function) function to calculate the sum of an expression across the group.

sumif() (aggregation function)

Learn how to use the sumif() (aggregation function) function to calculate the sum of an expression value in records for which the predicate evaluates to true.

take_any() (aggregation function)

Learn how to use the take_any() (aggregation function) to return the value of an arbitrarily selected record.

take_anyif() (aggregation function)

Learn how to use the take_anyif() function to return the value of an arbitrarily selected record for which the predicate is ’true'.

tdigest_merge() (aggregation functions)

Learn how to use the tdigest_merge() aggregation function to merge tdigest results across the group.

tdigest() (aggregation function)

Learn how to use the tdigest() (aggregation function) function to calculate the intermediate results of the weighted percentiles of expressions across the group.

variance() (aggregation function)

Learn how to use the variance() aggregation function to calculate the sample variance of the expression across the group.

varianceif() (aggregation function)

Learn how to use the varianceif() function to calculate the variance in an expression where the predicate evaluates to true.

variancep() (aggregation function)

Learn how to use the variancep() aggregation function to calculate the population variance of an expression across the group.