Skip to content

::WATERFALL

Dashboards: browser · CLI · servers Community extension: anofox_render

Bridge from a start total through signed steps (NULL / ::CATEGORY ‘total’ rows = totals).

Also spelled: ::BRIDGE

The minimal panel below, rendered

One row per step in order: ::XAXIS names it, the measure is the signed change; rows with a NULL measure or ::CATEGORY 'total' show the running total.

SELECT step ::XAXIS, delta ::WATERFALL, kind ::CATEGORY
FROM (VALUES (1,'Start',100,'total'),(2,'Price',20,NULL),(3,'Volume',-35,NULL),(4,'Mix',10,NULL),(5,'End',NULL,'total')) t(o, step, delta, kind) ORDER BY o;

Edit it in the builder ↗

From Which chart fits which question? — open it in the builder ↗:

SELECT 12::COL; SELECT step::XAXIS, eur::WATERFALL, '€'::YFORMAT, 'Volume beat budget; price and FX gave half of it back'::TITLE
FROM (VALUES (1, 'Budget', 480), (2, 'Volume', 95), (3, 'Price', -38), (4, 'Mix', 22), (5, 'FX', -17)) t(i, step, eur) ORDER BY i

Also in: Which claims can we fast-track?

::BARCHART · ::BARCHART_STACKED · ::BARCHART_PERCENT · ::BARCHART_STACKED_PERCENT · ::BULLET · ::FUNNEL · ::PARETO · ::GANTT