SHIFT

SHIFT

Description

Shifts the input node Node by a given offset Amount on the time dimension.

Signature

SHIFT(Node, TimeLevelNameNode)

Parameters

  • Node: Input node that is shifted, specified using the node name in single quotes (e.g. 'Profit')
  • TimeLevelName: Specifies the time level in which the offset is described using the level name in double quotes (e.g. "Year"). The input node is required to have data on this level
  • Amount: The offset to shift by (number)
  • New in version 2.14.0: Amount can be a node.

Example 1

Input Profit

Year

Profit

2015

35

2016

42

2017

47

Output SHIFT('Profit', "Year", -1)

Year

Profit

2015

 

2016

35

2017

42

2018

47

Example 2

Input Profit

Year Product Profit
2018 Car 50
2018 Van 25

Input Shift Node

Product Amount
Car -1
Van -2

Output SHIFT('Profit', "Year", 'Shift Node')

Year Product Profit
2019 Car 50
2020 Van 25



Was this helpful?

Yes | Somewhat | No