movingAverage() function

The movingAverage() function calculates the mean of values in the _values column grouped into n number of points.

Function type: Aggregate

movingAverage(n: 5)
Moving average rules
  • The average over a period populated by n values is equal to their algebraic mean.
  • The average over a period populated by only null values is null.
  • Moving averages skip null values.
  • If n is less than the number of records in a table, movingAverage returns the average of the available values.

Parameters

n

The number of points to average.

Data type: Integer

Examples

Calculate a five point moving average

from(bucket: "telegraf/autogen"):
  |> range(start: -12h)
  |> movingAverage(n: 5)

Table transformation with a two point moving average

Input table:
_time tag _value
0001 tv null
0002 tv 6
0003 tv 4
Query:
// ...
  |> movingAverage(n: 2 )
Output table:
_time tag _value
0002 tv 6
0003 tv 5

MOVING_AVERAGE

This documentation is open source. See a typo? Please, open an issue.


Need help getting up and running? Get Support