RATIO
Category: Math & numeric
⚠️ Important: End-Node Restriction.
The RATIO function must be an end node. It cannot be referenced by other nodes or used in further calculations. RATIO is designed for visualization and reporting purposes only. If you need a calculable ratio, see "Alternative: Division with Weighted-Average Aggregation" below.
Overview
The RATIO function divides one node by another while retaining only the dimensions shared by both nodes.
Unlike a standard division (Node1 / Node2), RATIO dynamically recalculates the ratio at every aggregation level displayed in the workspace.
Use this function when you need a ratio that stays correct across different aggregation levels in dashboards and reports.
Syntax
RATIO(Node1, Node2)
Example usage
RATIO('Revenue', 'Quantity')
Parameters
Parameter | Description | Type | Required |
|---|---|---|---|
Node1 (Dividend) | The node whose values are divided | Node reference | Yes |
Node2 (Divisor) | The node whose values divide Node1 | Node reference | Yes |
Output Shape
Aspect | Behavior |
|---|---|
Dimensionality | Only dimensions shared by both input nodes are kept |
Row count | Depends on shared dimensional combinations |
Aggregation | Values are recalculated dynamically per aggregation level in the workspace |
Watch Out
RATIO is not a standard calculation node.
The function cannot be referenced by other nodes.
The result is recomputed dynamically when the aggregation level changes.
Only shared dimensions between both nodes appear in the result.
Example
Input node: A
Year | Value |
|---|---|
2025 | 15 |
2026 | 28 |
2027 | 126 |
Input node: B
Year | Value |
|---|---|
2025 | 2 |
2026 | 2 |
2027 | 3 |
Formula
RATIO('A', 'B')
Year | → RATIO Result |
|---|---|
2025 | 7.5 |
2026 | 14 |
2027 | 42 |
Alternative
Division with Weighted-Average Aggregation
If you need a ratio result that can be used in further calculations, do not use RATIO.
Instead:
Create a regular division node:
'Node1' / 'Node2'Set the node's aggregation type to "weighted average" (with the divisor as the weight node).
This produces the same correctly weighted ratio across aggregation levels, but the result is a standard node that can be referenced by other calculations.
Related Functions
Function | When to use instead |
|---|---|
Standard division operator. Keeps the union of dimensions from both nodes | |
Division with validation options (e.g., fail on missing rows). |