Documentation

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:
_timetag_value
0001tvnull
0002tv6
0003tv4
Query:
// ...
  |> movingAverage(n: 2 )
Output table:
_timetag_value
0002tv6
0003tv5

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: