Basic Overview
Description | Returns the moving sum over the last WindowSize elements including the current one. If there are not enough elements with values null is returned. |
Syntax | MOVINGSUM(Node, TimeLevel, WindowSize) |
Parameters | - Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
- TimeLevel: Name of the time level that forms the time series to sum up (e.g. "Month")
- WindowSize: Number of elements (including the current one) to sum up (e.g. 3)
|
Example
Input Profit
Quarter | Profit |
2019-Q1 | 30 |
2019-Q2 | 120 |
2019-Q3 | 210 |
| 2019-Q4 | 300 |
Output MOVINGSUM('Profit',"Quarter",2)
Year | Profit |
2019-Q2 | 150 → (30+120) |
2019-Q3 | 330 → (120+210) |
2019-Q4 | 510 → (210+300) |