Hi Guys,
I have the following syntax for a data series chart to show planned vs actual velocity (currently just trying to show the planned velocity line). The set up is we have Card type: Iteration, with 2 fields, one is 'Planned velocity' and one is 'Actual velocity' both are manually entered. We use the Name of the card to denote the iteration (ie. Name = Iteration 1 etc)
See the image attached to see what the chart looks like. It seems to be pulling in the names of stories for the x axis even though I don't have anything in my query about card type = story.
Can you please help debug, we have tried a few other ways but they don't work either.
Thanks in advance!
a: SELECT Name, Sum('Planned velocity') WHERE 'Planned velocity' IS NOT NULL AND Type = Iteration color: red trend: true trend-line-width: 2 label: Planned
Comments
1 comment
Hi Ange,
Unfortunately, this is a limitation of the data series chart. Right now, the x-axis labels are not affected by the conditions parameter. In some situations, you can use x-labels-conditions to get around this, however this is not one of those cases. (We have a story to change that, but it has not been played yet.) One workaround that people have used is to create an "iteration name" property and then select that property rather than name in your series data parameter. I.e.,
{{data-series-chart
conditions: type = Iteration
cumulative: true
show-start-label: true
x-title: Time
y-title: Progress
chart-height: 500
chart-width: 800
series:
- data: SELECT "Iteration Name", Sum('Planned velocity') WHERE 'Planned velocity' IS NOT NULL AND Type = Iteration
color: red
trend: true
trend-line-width: 2
label: Planned
}}
"Iteration Name" has the same behavior as "Name", but tends to work because there are fewer "Iteration Name" values than "Name" values to show on the x-axis.
Thanks,
Jay
Please sign in to leave a comment.