Creating Historic Sprint Report with all issues

Hi - our team has a significant number of issues that carry-over from one sprint to the next. When we pull together reports using “Sprint” as the rows, it only pulls issues by their most recent sprint, rather than all issues that were ever in that Sprint (similar to how Jira default sprint reports would look). Is there a way around this?

I see all sprints listed for an issue in the “Issue Sprints” measure, but I’m not sure how to create a new measure to re-define how Sprint rows are calculated. Thanks!

Hi, @nickelodeon

Welcom to the eazyBI community.
I’m sorry for the late answer.

For Original estimated Hours please create the custom measure with the formula:

NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
   0
))

This measure checks if the issue was in the sprint at closing and shows that estimate, regardless of which sprint issue it currently belongs to.

Is that what you are looking for?

Kindly,
Ilze