SHIFT
Basic Overview
Description | Shifts the input node by a given offset amount on any dimension. | |||||||||||||||||||||||||||||||||||||||||||||||
Signature | SHIFT(Node, LevelName, ShiftAmount) | |||||||||||||||||||||||||||||||||||||||||||||||
Parameters |
| |||||||||||||||||||||||||||||||||||||||||||||||
Example 1 | Input Profit
Output SHIFT('Profit', "Year", -1)
| |||||||||||||||||||||||||||||||||||||||||||||||
Example 2 | Input Profit
Input Shift Node
Output SHIFT('Profit', "Year", 'Shift Node')
| |||||||||||||||||||||||||||||||||||||||||||||||
Example 3 | Available since: 3.7.0 Input Profit
Input Shift Node
Output SHIFT('Profit', "Year", 'Shift Node')
| |||||||||||||||||||||||||||||||||||||||||||||||
Example 4 | Available since: 3.9.0 Dimension: Vehicle
Input Profit
Input Shift Node
Output SHIFT('Profit', "Body Type", 'Shift 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 |
Example 3
AVAILABLE SINCE 3.7.0
Input Profit
Year | Product | Profit |
---|---|---|
2020 | Car | 100 |
2020 | Van | 200 |
2021 | Car | 120 |
2021 | Van | 220 |
2022 | Car | 150 |
2022 | Van | 250 |
Input Shift Node
Year | Amount |
---|---|
2020 | 0 |
2021 | 1 |
2022 | 2 |
Output SHIFT('Profit', "Year", 'Shift Node')
Year | Product | Profit |
---|---|---|
2020 | Car | 370 |
2020 | Van | 670 |
Example 4
AVAILABLE SINCE 3.9.0
Dimension: Vehicle
Vehicle | ||
---|---|---|
Category | Body Type | |
0 | Car | Compact |
1 | Car | Sedan |
2 | Van | Transporter |
3 | Truck | Trailer |
Input Profit
Year | Body Type | Tax |
---|---|---|
2020 | Compact | 100 |
2020 | Transporter | 200 |
2020 | Trailer | 1200 |
Input Shift Node
Body Type | Amount |
---|---|
Compact | 1 |
Transporter | 1 |
Trailer | 0 |
Output SHIFT('Profit', "Body Type", 'Shift Node')
Year | Body Type | Tax |
---|---|---|
2020 | Sedan | 200 |
2020 | Transporter | 1200 |