DPL Aggregations

This page contains the comprehensive list of available aggregations in Data Processing Language (DPL).

All aggregations in the list can be used with chart, stats and timechart commands.

Only linked commands works currently in Teragrep
Aggregation command Description

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()

Returns the chronologically earliest (oldest) seen occurrence of a value in the table column

earliest_time()

Returns the Unix time of the earliest (oldest) occurrence of a value in the table column

estdc()

Returns the estimated count of distinct values in the table column

exactperc()

Returns a percentile value in the numeric table column

first()

Returns the first seen value in the table column

last()

Returns the last seen value in the table column

latest()

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

latest_time()

Returns the Unix time of the latest (most recent) occurrence of a 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

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

upperperc()

Returns an approximate percentile value 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