How to create a Stack Bar chart showing % of Tasks completed by status

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a Task table, where each Task relate to a Dept and have Status =Open or Closed.

Like to create a stacked Bar chart:

  1. Each bar shows the % of Open vs Closed for a dept (the Y-axis should show % 0 to 100)

Unable to do it in QB, please help.

 

SR

Photo of SR

SR

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Melodie

Melodie

  • 0 Points
Hi there,

I believe you will want the X axis to be Department, Y axis to be # of Tasks, the Series to be Status and data labels to display value as "Percent of Series". Here is a screenshot to a similar set up, http://screencast.com/t/m7xLuHBkoG

And here is screenshot of what the stacked bar will look like, http://screencast.com/t/T6qabWzQ

Hope this helps!
James
QuickBase Cusotomer Support
Photo of SR

SR

  • 0 Points
Thanks for your reply. I already got what you are suggesting, but... Like to see each Dept total is 100% and thr Y axis to show % rather than # of Tasks
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
I suggest that you make a field which calculated to 0% of the task is incomplete and to 100% if the task is complete.  Then set the chart to show averages rather than totals.
Photo of SR

SR

  • 0 Points
Tried before but didn't work. I am trying to create a StackBar chart to show % Open in Red and Closed in green. The total % of Green and Red =100% for each Dept
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Can you make t wo fields.  One will be 100% if Open.  One will be 100% if closed.  Then use them both in the chart.  Show as Averages.
Photo of SR

SR

  • 0 Points
It worked. Thanks for your help :)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Thx for letting me know.
Photo of SR

SR

  • 0 Points
A quick Question: How to limit a bar Chart to only show top 8 to 10 bar not all if there are 50 bars?