How to filter for User Stories completed in a Sprint?

Gero Kassen_1q9aig

Hello everyone,

my question is regarding the filtering for User Stories that are completed in a Sprint. This seems quite trivial at first glance, but the problem arises, when a Story is worked on in multiple Sprints and then finished in only one Sprint.

Example: Work on User Stories starts in Sprint 3, does not get finished in Sprint 3 and 4 and then gets closed in Sprint 5.

Jira tracks this User Story in the Sprint Field with the values "Sprint3,Sprint4,Sprint 5".

When I want to analyse the data, lets say, in a pie chart on a dashboard and I filter for all User Stories completed in all Sprints and then group it in the pie chart for Sprint, the User Story will appear in all three Sprints, even though it was only completed in Sprint 5.

This problem then spills over into many other Use Cases, because no Jira native gadets, nor any other Marketplace solutions (for example the SumUp Plug-In that I am using) is able to differentiate between in which Sprint the User Story was worked on and in which Sprint it was actually finished. Therefore the data becomes useless, because the User Story and its Story Points will appear or gets summed up in multiple Sprints.

Did anyone encounter the same problem or even has a solution for this? 

Bill Sheboy

Hi @Gero Kassen 

Three ways I have seen teams address this Jira limitation is by:

• exporting the data and comparing Resolved to the sprint time range,
• purchasing marketplace add-ons with better sprint reporting, or
• using automation rules to flag when an issue finished during a sprint.

With the automation approach you could add a custom field, e.g. CompletedInSprint, which is set when the issue completes during a sprint.

For some teams I have supported, the root cause of this reporting need was carry over work from sprint to sprint.  We worked on that a bit to make carry over more of an exception rather than normal, reducing our need for such reporting.

Best regards,

Bill