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 isnull
. - 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:
_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 |
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.