QOQ_REL

Category: Compare periods

Overview

Description

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

Use this when you need the percentage change between consecutive quarters.

Syntax

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

Parameters

Node: Input node, specified using the node name 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_REL with the default behavior. The missing quarter 2026-Q1 is skipped and 2026-Q2 is not calculated.

Input node: Profit

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

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

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

Quarter	→ QOQ_REL Result
2025-Q2	(300 - 200) / 200 = 0.5
2025-Q3	150 / 300 = 0.5
2025-Q4	50 / 450 = 0.11
2026-Q1	(0 - 500) / 500 = -1
~~2026-Q2~~	(100 - 0) / 0 = division by zero results in entry not being present in result
2026-Q3	(0 - 100) / 100 = 0

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