Gauge Graph Readings

  • 0
  • 2
  • Question
  • Updated 11 months ago
  • In Progress
Does anyone know how to use the gauge graph to show budget used and remaining balance ? 

Say my budget is $300K and I have used $100K. It shows a green fill in the gauge with a $100k dollar amount. Im trying to get it to show another color and have it report $200K not used.
Photo of Christian Hilty

Christian Hilty

  • 100 Points 100 badge 2x thumb
  • Frustrated

Posted 11 months ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
Is this budget info on a single record or are there multiple records involved here.
Photo of Christian Hilty

Christian Hilty

  • 100 Points 100 badge 2x thumb
There are multiple deductions tallying to overall spend.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
The best I can think of is to use a chart of Type Line and Bar.  You can lookup the budget down to the deductions table and use that one a chart, with the bar being the total expenses and the line being the Average Budget.   This would need to be for a single Project.