WOW_ABS

In Compare periods

The WOW_ABS function returns the absolute growth for each week compared to the previous week (week-over-week).

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

Parameters

NodeNode referenceRequired

Input node, specified using the node name in single quotes (e.g. 'Profit')

MissingValueBehaviourKeywordOptional

How missing values are treated. Default: "IGNORE_MISSING".

• "IGNORE_MISSING": Missing rows are skipped. This is the default.
• "MISSING_AS_ZERO": Missing rows are treated as 0.

Examples

Default: ignoring missing values

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

Equivalent to: WOW_ABS('Profit', "IGNORE_MISSING")

Treating missing values as zero

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

See also

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.