DPL Aggregations

avg(), mean()

Returns the arithmetic mean of the table column

count(), c()

Returns the number of occurrences in the table column

distinct_count(), dc()

Returns the count of distinct values in the table column

earliest() or latest()

Returns chronologically the earliest (oldest) or latest (most recent) seen occurrence of a value in the table column

earliest_time() or latest_time()

Returns the Unix time of the earliest (oldest) or the latest (most recent) occurrence of a value in the table column

estdc()

Returns the estimated count of distinct values in the table column

first()

Returns the first seen value in the table column

last()

Returns the last seen value in the table column

list()

Returns a list of up to 100 values in the table column as a multi-value entry

median()

Returns the middle-most value in the table column

min() or max()

Returns either the minimum or the maximum value in the table column

mode()

Returns the most frequent value in the table column

perc(), upperperc() and exactperc()

Return the percentile value of the numeric table column

range()

Returns the difference between the maximum and minimum values in the table column (only if the values are numeric)

rate()

Returns the per-second rate change of the value in the table column

stdev()

Returns the sample standard deviation in the table column

stdevp()

Returns the population standard deviation in the table column

sum()

Sums all values in the table column

sumsq()

Sums the squares of the values in the table column

values()

Returns the list of all distinct values in the table column as a multi-value entry.

var()

Returns the sample variance in the table column

varp()

Returns the population variance in the table column