Skip to main content
Skip table of contents

QOQ_ABS

Basic Overview

Description

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

Syntax

QOQ_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 =

Quarter

Value

2019-Q1

200

2019-Q2

300

2019-Q3

450

2019-Q4

500

2020-Q2

100

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

Quarter

Value

2019-Q2

100

2019-Q3

150

2019-Q4

50

Output QOQ_ABS('Profit', "MISSING_AS_ZERO")

Quarter

Value

2019-Q1

200

2019-Q2

100

2019-Q3

150

2019-Q4

50

2020-Q1

-500

2020-Q2

100

2020-Q3

-100

JavaScript errors detected

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

If this problem persists, please contact our support.