QOQ_ABS

Category: Compare periods

Overview

Description

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

Use this when you need the absolute difference between consecutive quarters.

Syntax

QOQ_ABS('Node' [, "MissingValueBehaviour"])

Parameters

Node: Input node, specified in single quotes (e.g. 'Profit')
MissingValueBehaviour (optional): How missing values are treated.
- "IGNORE_MISSING" - Missing rows are skipped. This is the default.
- "MISSING_AS_ZERO" - Missing rows are treated as 0.

This example shows QOQ_ABS with the default behavior. The missing quarter 2026-Q1 is skipped and 2026-Q2 is not calculated.

Input node: Profit

Formula: QOQ_ABS('Profit') = QOQ_ABS('Profit', "IGNORE_MISSING")

With MISSING_AS_ZERO, gaps are filled with 0, producing results for every quarter including those without input data.

Formula: QOQ_ABS('Profit', "MISSING_AS_ZERO")

Function	When to use instead
QOQ_REL	When you need the percentage change quarter-over-quarter instead of the absolute difference.
YOY_ABS	When you need the absolute difference on a yearly basis instead of quarterly.
DELTA_ABS	When you need the absolute change along any dimension, not just time.