movingAverage() function

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

*Function type: Transformation*

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: "example-bucket"):
  |> range(start: -12h)
  |> movingAverage(n: 5)

Table transformation with a two point moving average

Input table:

Query:

// ...
  |> movingAverage(n: 2 )

Output table:

Related articles

• Calculate the moving average
• timedMovingAverage() function
• exponentialMovingAverage() function
• doubleEMA() function
• tripleEMA() function
• InfluxQL MOVING_AVERAGE()