PW

PW('Node')

The PW function shifts the input node one week into the future while retaining all other dimensions.

Use this function when you need last week’s values alongside current data for week-over-week comparisons.

Parameters

NodeNode referenceRequired: Input node that is shifted, specified using the node name in single quotes (e.g. 'Profit')

This function is only available on projects that use the week time dimension. A project has either Year, Quarter, Month and Day or Iso-Year, Week and Day, never both, so on a month-dimension project the node fails with an error saying the Week level could not be found. The time dimension is chosen per project, see Project Settings.

Each value appears one week later in the result.

Input node: 'Profit'

Formula: PW('Profit')

Nesting PW calls shifts values further into the future. Here, each value moves two weeks forward. Try SHIFT as an alternative with a custom offset.

Input node: 'Profit'

Formula: PW(PW('Profit'))

PY: When you need the previous year instead of the previous week.
SHIFT: When you need a custom offset or want to shift along a specific time level.
WOW_ABS: When you need the absolute difference to the previous week, not just the shifted values.