Aggregation functions

This section explains how to use and combine different aggregation functions in APL.

The table summarizes the aggregation functions available in APL. Use all these aggregation functions in the context of the summarize operator.

Function	Description
arg_min	Returns the row where an expression evaluates to the minimum value.
arg_max	Returns the row where an expression evaluates to the maximum value.
avg	Returns an average value across the group.
avgif	Calculates the average value of an expression in records for which the predicate evaluates to true.
count	Returns a count of the group without/with a predicate.
countif	Returns a count of rows for which the predicate evaluates to true.
dcount	Returns an estimate for the number of distinct values that are taken by a scalar an expressionession in the summary group.
dcountif	Returns an estimate of the number of distinct values of an expression of rows for which the predicate evaluates to true.
histogram	Returns a timeseries heatmap chart across the group.
make_list	Creates a dynamic JSON object (array) of all the values of an expression in the group.
make_list_if	Creates a dynamic JSON object (array) of an expression values in the group for which the predicate evaluates to true.
make_set	Creates a dynamic JSON array of the set of distinct values that an expression takes in the group.
make_set_if	Creates a dynamic JSON object (array) of the set of distinct values that an expression takes in records for which the predicate evaluates to true.
max	Returns the maximum value across the group.
maxif	Calculates the maximum value of an expression in records for which the predicate evaluates to true.
min	Returns the minimum value across the group.
minif	Returns the minimum of an expression in records for which the predicate evaluates to true.
percentile	Calculates the requested percentiles of the group and produces a timeseries chart.
percentileif	Calculates the requested percentiles of the field for the rows where the predicate evaluates to true.
percentiles_array	Returns an array of numbers where each element is the value at the corresponding percentile.
percentiles_arrayif	Returns an array of percentile values for the records that satisfy the condition.
rate	Calculates the rate of values in a group per second.
stdev	Calculates the standard deviation of an expression across the group.
stdevif	Calculates the standard deviation of an expression in records for which the predicate evaluates to true.
sum	Calculates the sum of an expression across the group.
sumif	Calculates the sum of an expression in records for which the predicate evaluates to true.
topk	Calculates the top values of an expression across the group in a dataset.
topkif	Calculates the top values of an expression in records for which the predicate evaluates to true.
variance	Calculates the variance of an expression across the group.
varianceif	Calculates the variance of an expression in records for which the predicate evaluates to true.