Calculate the moving average

Use movingAverage() or timedMovingAverage() to return the moving average of data.

1. data
2. |> movingAverage(n: 5)

4. // OR

6. data
7. |> timedMovingAverage(every: 5m, period: 10m)

movingAverage()

For each row in a table, movingAverage() returns the average of the current value and previous values where n is the total number of values used to calculate the average.

If n = 3:

Given the following input:

The following would return:

1. |> movingAverage(n: 3)

timedMovingAverage()

For each row in a table, timedMovingAverage() returns the average of the current value and all row values in the previous period (duration). It returns moving averages at a frequency defined by the every parameter.

Each color in the diagram below represents a period of time used to calculate an average and the time a point representing the average is returned. If every = 30m and period = 1h:

Given the following input:

The following would return:

1. |> timedMovingAverage(every: 30m, period: 1h)

Related

• movingAverage() function
• timedMovingAverage() function

query moving average