Related to "Selectors"
aggregateWindow() function
aggregateWindow() downsamples data by grouping data into fixed windows of time and applying an aggregate or selector function to each window.
bottom() function
bottom() sorts each input table by specified columns and keeps the bottom n records in each table.
distinct() function
distinct() returns all unique values in a specified column.
experimental.distinct() function
experimental.distinct() returns unique values from the _value column.
experimental.first() function
experimental.first() returns the first record with a non-null value in the _value column for each input table.
experimental.last() function
experimental.last() returns the last record with a non-null value in the _value column for each input table.
experimental.max() function
experimental.max() returns the record with the highest value in the _value column for each input table.
experimental.min() function
experimental.min() returns the record with the lowest value in the _value column for each input table.
experimental.quantile() function
experimental.quantile() returns non-null records with values in the _value column that fall within the specified quantile or represent the specified quantile.
experimental.unique() function
experimental.unique() returns all records containing unique values in the _value column.
first() function
first() returns the first non-null record from each input table.
highestAverage() function
highestAverage() calculates the average of each input table and returns the highest n averages.
highestCurrent() function
highestCurrent() selects the last record from each input table and returns the highest n records.
highestMax() function
highestMax() selects the record with the highest value in the specified column from each input table and returns the highest n records.
last() function
last() returns the last row with a non-null value from each input table.
limit() function
limit() returns the first n rows after the specified offset from each input table.
lowestAverage() function
lowestAverage() calculates the average of each input table and returns the lowest n averages.
lowestCurrent() function
lowestCurrent() selects the last record from each input table and returns the lowest n records.
lowestMin() function
lowestMin() selects the record with the lowest value in the specified column from each input table and returns the bottom n records.
max() function
max() returns the row with the maximum value in a specified column from each input table.
median() function
median() 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 (50th percentile).
min() function
min() returns the row with the minimum value in a specified column from each input table.
quantile() function
quantile() returns rows from each input table with values that fall within a specified quantile or returns the row with the value that represents the specified quantile.
sample() function
sample() selects a subset of the rows from each input table.
top() function
top() sorts each input table by specified columns and keeps the top n records in each table.
unique() function
unique() returns all records containing unique values in a specified column.