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