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.