WOW_REL

Category: Compare periods

Overview

Description

Returns the relative growth for each week compared to the previous week (week-over-week).

Use this when you need the percentage change between consecutive weeks.

Syntax

WOW_REL('Node' [, "MissingValueBehaviour"])

Parameters

Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
MissingValueBehaviour (optional): How missing values are treated.
- "IGNORE_MISSING" - Missing rows are skipped. This is the default.
- "MISSING_AS_ZERO" - Missing rows are treated as 0.

This example shows WOW_REL with the default behavior. The missing weeks are skipped and no result is produced for them.

Input node: Profit

Formula: WOW_REL('Profit') = WOW_REL('Profit', "IGNORE_MISSING")

With MISSING_AS_ZERO, gaps are filled with 0, producing results for every week including those without input data.

Formula: WOW_REL('Profit', "MISSING_AS_ZERO")

Week	→ WOW_REL Result
2025-W02	(300 - 200) / 200 = 0.5
2025-W03	150 / 300 = 0.5
2025-W04	50 / 450 = 0.11
2025-W04	(0 - 500) / 500 = -1
~~2026-W06~~	(100 - 0) / 0 = division by zero results in entry not being present in result
2026-W07	(0 - 100) / 100 = -1

Function	When to use instead
WOW_ABS	When you need the absolute difference week-over-week instead of a percentage.
YOY_REL	When you need the percentage change on a yearly basis instead of weekly.
DELTA_REL	When you need relative change along any dimension, not just time.