Skip to content

::BULLET

Dashboards: browser · CLI · servers Community extension: anofox_render

Measure per XAXIS row vs a ::GOAL tick over ::RANGE bands ‘60,80,100’.

Also spelled: ::BULLETCHART

The minimal panel below, rendered

One row per item: ::XAXIS names it, the measure is the bar, ::GOAL the tick, ::RANGE '60,80,100' the bands.

SELECT team ::XAXIS, score ::BULLET, 85 ::GOAL, '60,80,100' ::RANGE
FROM (VALUES ('Support',78),('Sales',91),('Ops',64)) t(team, score);

Edit it in the builder ↗

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

SELECT 6::COL; SELECT region::XAXIS, attained::BULLET, goal::GOAL, '60,85,110'::RANGE, '%'::YFORMAT, 'Two regions short of target'::TITLE
FROM (VALUES (1, 'North', 92, 90), (2, 'South', 71, 85), (3, 'East', 104, 95), (4, 'West', 66, 80)) t(i, region, attained, goal) ORDER BY i

Also in: What should we order this week to sell the most?

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