Track issues spill over from each sprint

Question

Hi,

We need to be able to track our issues spill over from each sprint

For example,

Sprint 12 issue count = 100 and we were only able to close 80, so 20 issues will spill over to next sprint.

We would need to report the new sprint 13 issues(100) + the 20 spill over issues, bringing the total to 120 issues for Sprint 13.

I really appreciate if there is a way to find this using JQL or eazyBI report.

Thanks in advance!

Daina Tupule eazyBI · Answer

You would like to use a calculation in eazyBI to check if the issue currently in this sprint was in the previous sprint as well. Here is an example formula for this:

CASE WHEN
[Sprint].CurrentMember.Level.name = "Sprint"
THEN
NonZero(SUM(
Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
-- issue is in current/last Sprint
[Measures].[Issue Sprint] = [Sprint].CurrentMember.Name
),
CASE WHEN
-- issue was in the previous sprint as well
([Measures].[Transitions to],
[Sprint Status].[Active],
[Sprint].CurrentMember.PrevMember) > 0
THEN
-- count it in and validate with any other selections in report
[Measures].[Transitions to issues count]
END
))
END

There is a similar topic in eazyBI community portal with a bit more advanced setup to cover cases when an issue was moved over several sprints.

Daina / support@eazybi.com

Nic Brough -Adaptavist- · Answer

When an issue goes into a sprint, the sprint gets named on the issue, and it remains there when issues go into the next sprint, so you could write:

sprint = "sprint 12" and sprint = "sprint 13"