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

Bud Herz May 21, 2021

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? 

 

1 answer

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 21, 2021

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

Bud Herz May 21, 2021

Bill you're answering another one of my questions?! Good to hear from you again. 
I will try those out and see. Thanks, much appreciated. 

The custom field is always the Sprint name. We use it to sometimes identify one-off Sprints (for patch work, etc) and to standardize it, the normal Sprint name if a regular one. 

Bud Herz May 25, 2021

Those worked perfectly! Thank you.

Like Bill Sheboy likes this
tinneke_huizinga
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 22, 2021

interesting and this helps me to understand how many stories we dragged along from previous sprints into the active sprints, but I would like to have an additional idea how to calculate how often this happens over a period of time. Any ideas on this? 

Like # people like this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 22, 2021

Hi @tinneke_huizinga -- Welcome to the Atlassian Community!

There are probably marketplace addons to report things like that...

Or, you could use custom fields and automation rules, capturing when an issue gets carried over to a new sprint.  Then use a JQL filter on the custom field to report counts/frequency. 

If you specifically need the counts over time, consider doing the above and then exporting the results for analysis in a spreadsheet.  As this is often a short-term/correctable symptom (i.e. carry-over) you may not want to build anything too elaborate, or purchase an addon app.

Kind regards,
Bill

Terence.Law
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 5, 2021

@Bill Sheboy  is there a way to call out only those stories that have rolled over more than x sprints?  

 

ie. only show those stories that have rolled over 2 sprints

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 5, 2021

Hi @Terence.Law 

Yes, but not with out-of-the-box JQL...and the solution approach you consider may depend on how often you need to perform this check:

One time: Export your issues to a spreadsheet and use a formula to count the number of entries for the sprint field...which will expand to multiple columns during export.

Many times: Consider either a marketplace addon or use a custom field and an automation rule to count an issue's sprints when the field changes.  You do not note if you are using Jira Cloud or Server/Data Center, so... automation is included for free with Cloud and is available as either a free (Lite) or paid (Pro) addon for Server/Data Center.

Kind regards,
Bill

Like # people like this
Bud Herz April 26, 2024

@Terence.Law  - I noticed you wanted to know which stories rolled over more than X number of times. 

We've created a field that increments each time a ticket in QA Review. We can then track which tickets came through QA more than once.

You could do the same and use the incrementing Sprint field to track any threshold you're looking for. 

Suggest an answer

Log in or Sign up to answer