How can we show issue count rolling over Sprint to Sprint?

Bud Herz_4dzuwt

Some issues unfortunately rollover from one Sprint to the next. 

Is there a way in JQL to feed a metric showing how many carry over? Not entirely sure yet how to do this, but metrics like these would help our 'New to Agile' team see where they're having challenges.

A metric like:
1) Issue count in current Sprint also found in previous Sprint
2) Number of Sprints that issues have been in   

We have a custom 'Sprint' field so there should be data historically to calculate, right? 

 

Bill Sheboy

Hi @Bud Herz 

You could do this with the sprint report, and/or some JQL to get the various numbers, and/or show those as saved filters on a dashboard, and/or use an automation rule triggered on sprint completed to send a report.

Some example queries would be:

• Issues in the current sprint and prior sprints: 

project = myProject
 AND sprint IN openSprints()
 AND sprint IN closedSprints()
 ORDER BY Key ASC

• Issues only in this sprint and no others:

project = myProject
 AND sprint IN openSprints()
 AND sprint NOT IN closedSprints()
 ORDER BY Key ASC

What does your custom sprint field represent?

Best regards,

Bill