::FUNNEL
Dashboards: browser · CLI · servers
Community extension: anofox_render


Ordered XAXIS stages, widths by value, conversion % from the previous stage.
Also spelled: ::FUNNELCHART
The data it needs
Section titled “The data it needs”One row per stage in order: ::XAXIS names it, the measure is the count; each stage shows its conversion from the one before.
SELECT stage ::XAXIS, n ::FUNNELFROM (VALUES (1,'Visit',1000),(2,'Sign-up',420),(3,'Trial',180),(4,'Paid',60)) t(o, stage, n) ORDER BY o;In an example
Section titled “In an example”From Which chart fits which question? — open it in the builder ↗:
SELECT 6::COL; SELECT stage::XAXIS, n::FUNNEL, 'A quarter of sign-ups never start a trial'::TITLEFROM (VALUES (1, 'Visits', 48000), (2, 'Sign-ups', 6200), (3, 'Trials', 4650), (4, 'Paid', 1180)) t(i, stage, n) ORDER BY iAlso in: Who should sales call first?
Related
Section titled “Related”::BARCHART · ::BARCHART_STACKED · ::BARCHART_PERCENT · ::BARCHART_STACKED_PERCENT · ::WATERFALL · ::BULLET · ::PARETO · ::GANTT