WOW_ABS

Category: Compare periods

Overview

Description

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

Use this when you need the absolute difference between consecutive weeks.

Syntax

WOW_ABS('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_ABS with the default behavior. The missing week W05 is skipped and no result is produced for it.

Input node: Profit

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

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

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

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