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: