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-Q4300

Output MOVINGSUM('Profit',"Quarter",2)

Year

Profit

2019-Q2

150 → (30+120)

2019-Q3

330 → (120+210)

2019-Q4

510 → (210+300)