Related to "aggregates"
count() function
The count()
function outputs the number of non-null records in a column.
histogramQuantile() function
The histogramQuantile()
function approximates a quantile given a histogram that approximates the cumulative distribution of the dataset.
integral() function
The integral()
function computes the area under the curve per unit of time of subsequent non-null records.
mean() function
The mean()
function computes the mean or average of non-null records in the input table.
median() function
The median()
function returns the median _value
of an input table or all non-null records in the input table with values that fall within the 0.5
quantile or 50th percentile.
mode() function
The mode()
function computes the mode or value that occurs most often in a specified column in the input table.
quantile() function
The quantile()
function outputs non-null records with values that fall within the specified quantile or the non-null record with the value that represents the specified quantile.
reduce() function
The reduce()
function aggregates records in each table according to the reducer, fn
, providing a way to create custom table aggregations.
skew() function
The skew()
function outputs the skew of non-null records as a float.
spread() function
The spread()
function outputs the difference between the minimum and maximum values in a specified column.
stddev() function
The stddev()
function computes the standard deviation of non-null records in a specified column.
sum() function
The sum()
function computes the sum of non-null records in a specified column.
timeWeightedAvg() function
The timeWeightedAvg()
function outputs the timeWeightedAvg of non-null records as a float.
experimental.count() function
The experimental.count()
function outputs the number of records in each input table and returns the count in the _value
column.
experimental.histogramQuantile() function
The experimental.histogramQuantile()
function approximates a quantile given a histogram with the cumulative distribution of the dataset.
experimental.integral() function
The integral()
function computes the area under the curve per unit of time of subsequent non-null records. Input tables must have _time
and _value
columns.
experimental.mean() function
The experimental.mean()
function computes the mean or average of non-null values in the _value
column of each input table.
experimental.mode() function
The experimental.mode()
function computes the mode or value that occurs most often in the _value
column in each input table.
experimental.quantile() function
The experimental.quantile()
function outputs non-null records with values in the _value
column that fall within the specified quantile or the non-null record with the value in the _value
column that represents the specified quantile.
experimental.skew() function
The experimental.skew()
function outputs the skew of non-null values in the _value
column for each input table.
experimental.spread() function
The experimental.spread()
function outputs the difference between the minimum and maximum values in the _value
column for each input table.
experimental.stddev() function
The experimental.stddev()
function computes the standard deviation of non-null values in the _value
column for each input table.
experimental.sum() function
The experimental.sum()
function computes the sum of non-null records in a specified column.
geo.ST_LineString() function
The geo.ST_LineString()
function converts a series of geographic points into linestring.
oee.APQ() function
The oee.APQ()
function computes availability, performance, and quality (APQ) and overall equipment effectiveness (OEE).
oee.computeAPQ() function
The oee.computeAPQ()
function computes availability, performance, and quality (APQ) and overall equipment effectiveness (OEE) using two separate input streams—production events and parts events.
prometheus.histogramQuantile() function
The prometheus.histogramQuantile()
function calculates quantiles on a set of values assuming the given histogram data is scraped or read from a Prometheus data source.