TIMELAG

TIMELAG

Description

This function calculates time-lagged effects on the given time granularity. You can use the function to model specific growth curves or delayed effects.

Signature

TIMELAG(ValueNodeTimeLagNodeTimeLevel)

Parameters

  • ValueNode: Input node with the values that should be time-lagged. Must have the TimeLevel.
  • TimeLagNode: Node that contains a measure between 0 and 1 (= 100%) on the Sequence dimension, defining how the time lag is applied. Sequence entry 0 refers to the impact in the base year. The node should not have the TimeLevel and usually contains values for the sequence until 1.0 is reached.
  • TimeLevel: Name of the time level where one time level step equals one sequence step.

Example

Input Investment

Year

Investment

2015

10

2016

0

2017

15

2018

0

Example

Input TimeLagNode

Sequence

Effect

0

0

1

0.25

2

0.5

3

1

Output TIMELAG('Investment', 'TimeLagNode', "Year")

Year

Measure

2015

0

2016

2.5

2017

5

2018

10+3.75

2019

10+7.5

2020

10+15

Was this helpful?

Yes | Somewhat | No