For some reason I can't get the ratio bar chart to do percentages. I know it is something simple that I am missing. My chart has bars at 100% or 0 and I am trying to track the percent complete on each story. Each story has the properties: 'Original Esitimate' - which is the number of hours thought to be needed to complete the story, 'Worked Time' - which is how much time that has already been spent on the story, and 'Percent Worked' - which is the percentage done on the story so far.
My ratio bar chart code looks like this:
ratio-bar-chart
totals: SELECT 'number', SUM('Percent Worked') WHERE Type = Story AND 'Planning - Sprint' = (CURRENT SPRINT)
restrict-ratio-with: Status < Closed
Comments
2 comments
Hi Caleb:
I can understand why your ratio bar chart always gives you 100% or 0. In your example, each bar represents an individual story card, and the "restrict-ratio-with" condition is "status < close". So, for each bar, it is either "status < close" or "status >= close". That's why the percentage of "status < close" is either 100% or 0.
For the chart you need. I think you can try this one:
{{
stack-bar-chart
conditions: Type = Story AND 'Planning - Sprint' = (CURRENT SPRINT)
cumulative: false
labels: SELECT number
series:
- data: SELECT number, sum("Percent Worked")
label: Series
combine: overlay-bottom
}}
This charts may not be able give you nice percentage number as value of y-axix, however it should be able to provide the story completion information you need. Let me know whether this works for you. And also you can find more information about Mingle chart on this help link.
Thank you very much!
-- Huimin
Thank you Huimin. The stack-bar-chart fills my needs better than the ratio-bar-chart did. Thank you for the comment and suggestion.
Please sign in to leave a comment.