Issue in multiple sprints - need help

Hey guys,

I’m trying to get the last 3 sprints sum of issues cycle time , but there is a problem , there is issues that are in multiple sprints as you see in the attached pic ( MIMS-28787 )

So if i want the sum of its cycle time i can’t ,
this is my formula for [Last 3 sprints - Sum Cycle Time Days] :
Sum(
Head(Order(
Filter(
[Sprint].CurrentHierarchyMember.Children,
[Measures].[Sprint closed?]=“Yes”
),
[Measures].[Sprint start date],
DESC
),3),
[Measures].[Cycle Time Days]
)
and this is [Cycle Time Days] :
DateDiffDays(
(
[Measures].[Transition to status first date],
[Transition Status].[MIMSInDevX]
),
(
[Measures].[Transition to status first date],
[Transition Status].[MIMSDoneX]
)
)
and this [Sum cycle time] formula:
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
NOT IsEmpty([Measures].[Cycle Time Days])
),
[Measures].[Cycle Time Days]
)

i don’t know what is the solution , please help

Hi, @Nada

Welcom to the eazyBI community.

Since the measure uses transitions, the issue is shown for each sprint where these transitions have happened.

If you want to see the issue only once, please add the real measure “Issues Created” and filter the column > 0.

Please draw the report you want to see.

Kindly,
Ilze