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.
data-series-chart
conditions: 'Type' = 'Defect' and Release = (Current Release)
x-title: Iteration
y-title: Number of Defects Found/Fixed
x-labels-conditions: Type = Iteration
cumulative: true
plot-x-offset: 90
chart-height: 300
chart-width: 400
legend-max-width: 100
chart-type: line
series:
- label: Newly Opened Defects
color: red
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
color: green
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.
Comments
1 comment
I seem to have figured out a way to do this. I just changed things slightly:
{{
data-series-chart
conditions: 'Release' = (Current Release) AND 'Type' = 'Defect'
cumulative: false
x-labels-start:
x-labels-end: (Current Iteration)
x-labels-step:
x-labels-conditions: Type = Iteration
x-title: Iteration
y-title: Number of Defects
chart-height: 400
chart-width: 600
legend-max-width: 200
show-start-label: true
series:
- label: Opened
color: red
data: SELECT 'Defect Reported in Iteration', COUNT(*) WHERE 'Defect Reported in Iteration' IS NOT NULL and 'Defect Status' IS NOT NULL
- label: Resolved
color: green
data: SELECT 'Defect Closed in Iteration', COUNT(*) WHERE 'Defect Closed in Iteration' IS NOT NULL
}}
Please sign in to leave a comment.