movingAverage() function

Warning! This page documents an earlier version of Flux, which is no longer actively developed. Flux v0.65 is the most recent stable version of Flux.

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