::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 data it needs
Section titled “The data it needs”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 ::CATEGORYFROM (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;In an example
Section titled “In an example”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'::TITLEFROM (VALUES (1, 'Budget', 480), (2, 'Volume', 95), (3, 'Price', -38), (4, 'Mix', 22), (5, 'FX', -17)) t(i, step, eur) ORDER BY iAlso in: Which claims can we fast-track?
Related
Section titled “Related”::BARCHART · ::BARCHART_STACKED · ::BARCHART_PERCENT · ::BARCHART_STACKED_PERCENT · ::BULLET · ::FUNNEL · ::PARETO · ::GANTT