Skip to content

::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 minimal panel below, rendered

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 ::XMAX
FROM (VALUES ('Berlin',80,95),('Hamburg',70,66),('Munich',60,88)) t(store, y2025, y2026);

Edit it in the builder ↗

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)'::TITLE
FROM (VALUES ('Berlin', 120, 138), ('Hamburg', 100, 92), ('Munich', 140, 151), ('Cologne', 90, 97)) v(store, plan, actual)

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