PW
Basic Overview
Description | Shifts the input node Node one week into the future while retaining all other dimensions. Available since: 3.8.0 |
Signature | PW(Node) |
Parameters |
|
Example 1
Input Profit
Week | Profit |
2019-W01 | 35 |
2019-W02 | 42 |
2019-W03 | 47 |
Output PW('Profit')
Week | Profit |
2019-W02 | 35 |
2019-W03 | 42 |
2019-W04 | 47 |
Example 2
SHIFT or Nested PW expressions can be used to move Nodes further into the future.
Input Profit
Week | Profit |
2019-W01 | 38 |
2019-W02 | 45 |
2019-W03 | 52 |
Output PW(PW('Profit'))
Week | Profit |
2019-W03 | 38 |
2019-W04 | 45 |
2019-W05 | 52 |