MOVINGAVG
Basic Overview
Description | Returns the moving average over the last WindowSize elements including the current one. If there are not enough elements with values null is returned. |
---|---|
Syntax | MOVINGAVG(Node, TimeLevel, WindowSize) |
Parameters |
|
Example
Input Profit
Quarter | Profit |
---|---|
2019-Q1 | 30 |
2019-Q2 | 120 |
2019-Q3 | 210 |
2019-Q4 | 300 |
Output MOVINGAVG('Profit',"Quarter",2)
Year | Profit |
---|---|
2019-Q2 | 75 → (30+120)/2 |
2019-Q3 | 165 → (120+210)/2 |
2019-Q4 | 255 → (210+300)/2 |