Skip to main content
Skip table of contents

WOW_REL

Basic Overview

Description

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

Available since: 3.8.0

Syntax

WOW_REL(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

2020-W06

100

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

Year

Value

2019-W02

(300 - 200) / 200 = 0.5

2019-W03

150 / 300 = 0.5

2019-W04

50 / 450 = 0.11

Output WOW_REL('Profit', "MISSING_AS_ZERO")

Year

Value

2019-W02

(300 - 200) / 200 = 0.5

2019-W03

150 / 300 = 0.5

2019-W04

50 / 450 = 0.11

2019-W04

(0 - 500) / 500 = -1

2020-W06

(100 - 0) / 0 = division by zero results in entry not being present in result

2020-W07

(0 - 100) / 100 = -1

JavaScript errors detected

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

If this problem persists, please contact our support.