Skip to main content
Question

Gauge Report for action items - Goal 0

  • Jul 22, 2026 8:09 PM UTC
  • 3 replies
  • 92 views

Forum|alt.badge.img

Looking to have a gauge chart with 0 entries being what good looks like. We are using it to identify action items for our team. As QuickBase won't allow you to have your start larger than your goal, and results displaying based on a percentage, it makes setting the colors for the gauge super challenging as well. 

Any suggestions?

 

3 replies

MarkShnierYou
Forum|alt.badge.img+24

Try setting the goal to be 0.1


scboat
Forum|alt.badge.img
  • Qrew Cadet
  • Jul 27, 2026 3:25 PM UTC

I leave my start at 0, and then just change the colors so that lower numbers are green and higher numbers are red, and then hide the goal or set it as part of the label.  


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 15, 2026 1:38 AM UTC

Building on Mark's tip: Goal of 0 isn't supported because Start has to be below Goal and the fill is a percentage of the Goal. 0.1 works as a tiny Goal, but you can get cleaner colors without fighting a near-zero Goal.

Keep Start at 0 and set Goal to a realistic "bad" ceiling for open action items (for example 20). The gauge is empty at 0 and full when you hit that ceiling.

Then flip the ranges so low counts look good. Color is driven by percent of Goal: set Low to green (say under 25%), Medium to yellow, High to red. At 0 open items you're at 0% of Goal, so you land in Low / green. As the count climbs you move through yellow into red.

That keeps the native gauge behavior and matches "0 is good" without a Goal of 0.

https://help.quickbase.com/docs/creating-a-gauge-chart