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