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:
totals: SELECT 'number', SUM('Percent Worked') WHERE Type = Story AND 'Planning - Sprint' = (CURRENT SPRINT)
restrict-ratio-with: Status < Closed