Flux built-in aggregate transformations
Flux’s built-in aggregate transformations take values from an input table and aggregate them in some way. Output tables contain a single row with the aggregated value.
Aggregate operations output a table for every input table they receive. You must provide a column to aggregate. Any output table will have the following properties:
- It always contains a single record.
- It will have the same group key as the input table.
- It will contain a column for the provided aggregate column.
The column label will be the same as the input table.
The type of the column depends on the specific aggregate operation.
The value of the column will be
null
if the input table is empty or the input column has onlynull
values. - It will not have a
_time
column.
aggregateWindow helper function
The aggregateWindow()
function
does most of the work needed when aggregating data.
It windows and aggregates the data, then combines windowed tables into a single output table.
Aggregate functions
The following aggregate functions are available:
Aggregate selectors
The following functions are both aggregates and selectors.
Each returns n
values after performing an aggregate operation.
They are categorized as selector functions in this documentation:
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.