I'm making use of the Iteration cards and a tree that goes Release>Iteration>Story>Defect. I want to create a chart that shows the number of defects opened and closed each iteration. But I only want to show iterations that have already happened, not future ones.
The following gives me almost what I need. Except I want the line to stop at the current iteration, which is iteration #1.
conditions: 'Type' = 'Defect' and Release = (Current Release)
y-title: Number of Defects Found/Fixed
x-labels-conditions: Type = Iteration
- label: Newly Opened Defects
data: SELECT 'Defect Reported in Iteration', COUNT(*) WHERE 'Defect Reported in Iteration' IS NOT NULL and 'Defect Status' IS NOT NULL
- label: Defects Resolved in Iteration
data: SELECT 'Defect closed in Iteration', COUNT(*) WHERE 'Defect Closed in Iteration' IS NOT NULL
Attached is the resulting chart.
I've tried to play around with other settings to no avail. I also have a project variable called (Current Iteration) set to the current Iteration card that I could use.
BTW - it's really annoying that when using the iteration cards in the chart it displays the card number. If there is a way to turn that off please let me know.