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


Two values per item (this column names it) joined by a line: ::XMIN → ::XMAX (before/after, plan/actual).
Also spelled: ::DUMBBELLCHART, ::SLOPE
The data it needs
Section titled “The data it needs”One row per item: this column names it, ::XMIN and ::XMAX are the two values (before/after, plan/actual).
SELECT store ::DUMBBELL, y2025 ::XMIN, y2026 ::XMAXFROM (VALUES ('Berlin',80,95),('Hamburg',70,66),('Munich',60,88)) t(store, y2025, y2026);In an example
Section titled “In an example”From Which chart fits which question? — open it in the builder ↗:
SELECT 6::COL; SELECT store::DUMBBELL, plan::XMIN, actual::XMAX, 'Plan → actual per store (::DUMBBELL)'::TITLEFROM (VALUES ('Berlin', 120, 138), ('Hamburg', 100, 92), ('Munich', 140, 151), ('Cologne', 90, 97)) v(store, plan, actual)Related
Section titled “Related”::BARCHART · ::BARCHART_STACKED · ::BARCHART_PERCENT · ::BARCHART_STACKED_PERCENT · ::WATERFALL · ::BULLET · ::FUNNEL · ::PARETO