Filters for 3 Metrics for lingering issues

Tim Dowd

I am looking for a way to filter for the following 3 issue conditions to help find lingering issues:

1. Length of time issue took from In Progress to Resolved (days or sprints, etc.)
2. # of issues In Progress carried over to next sprint
3. # of times an issue went from Resolved back to In Progress

I only have out of the box features in JIRA. Thanks in advance!

Bill Sheboy

Hi @Tim Dowd 

1). I do not believe you can do this one with out-of-the-box Jira...you will need an add-on to enhance filtering/reporting, or to repeatedly use the control chart and change the settings to measure the time.

2). For this one, try the following when the active sprint is running:

project = project_name
 AND statusCategory IN ("To Do", "In Progress")
 AND Sprint IN closedSprints()
 AND Sprint IN openSprints()

Once the sprint is ended, you could instead export data to a spreadsheet to parse the multiple exported sprint id columns.

3). This one will also need some form of add-on, or access to the logging to count the status transitions.

Best regards,
Bill