Skip to main content
Skip table of contents

WOW_ABS

Basic Overview

Description

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

Available since: 3.8.0

Syntax

WOW_ABS(Node <, MissingValueBehaviour>)

Parameter

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

  • MissingValueBehaviour:

    • how the function should treat missing values

    • possible value are: IGNORE_MISSING (default) and MISSING_AS_ZERO

Example

Input Profit =

Week

Value

2019-W01

200

2019-W02

300

2019-W03

450

2019-W04

500

2019-W06

100

Output WOW_ABS('Profit') =  WOW_ABS('Profit', "IGNORE_MISSING")

Week

Value

2019-W02

100

2019-W03

150

2019-W04

50

Output WOW_ABS('Profit', "MISSING_AS_ZERO")

Week

Value

2019-W01

200

2019-W02

100

2019-W03

150

2019-W04

50

2019-W05

-500

2019-W06

100

2019-W07

-100

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.