Budget vs Actual donut chart

  • 1
  • Question
  • Updated 4 months ago
  • In Progress
I am trying to create a dashboard for our app that shows budget vs actual for labor and expenses.  I want to have a donut chart that show the % of the budgeted amount that the actual is.  The full circle is the budgeted amount, the slice is the value of the current actual and the center is the %
Photo of Chad Gill

Chad Gill

  • 1,194 Points 1k badge 2x thumb

Posted 4 months ago

  • 1
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Hmmm ... don't work with pie charts too often but you could likely do this by getting the actual amount and yet to be used amount in two separate models/series. Basically one row each with the respective amounts.

Model#1: YetToBeUsedFromBudgetAmount
Model#2: ActualAmount
Photo of Chad Gill

Chad Gill

  • 1,194 Points 1k badge 2x thumb


I can show the series but the problem is the donut shows them as separate amounts when what i want is the actual to cover the budgeted as we use it.  In this case the number in the middle should be 78% mean we have used 78% of our budgeted expenses.
Photo of Chad Gill

Chad Gill

  • 1,194 Points 1k badge 2x thumb
i guess what i am actually looking for is more like a guage chart but not sure how to do that in skuid
Photo of Chad Gill

Chad Gill

  • 1,194 Points 1k badge 2x thumb
Photo of Chad Gill

Chad Gill

  • 1,194 Points 1k badge 2x thumb
I may be alone out here but just in case, we got this to work by charting two series.  We rolled up the actual usages and set one series as the total.  We then set the other series to the (budget amount minus the rolled up amount.)  Then bazinga! we have a sorta gauge chart  
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Da man!