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