PW

Category: Compare periods

Overview

Description

Shifts the input node Node one week into the future while retaining all other dimensions.

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

Syntax

PW('Node')

Parameters

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

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'))

Function	When to use instead
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.