Hi,
I am using the below calculation to calculate total resolution time minus the time spent in the transition status Draft and Live.
NonZero(
Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.get(‘Resolved at’),
[Time].CurrentHierarchyMember
)
and
[Measures].[Issues resolved]>0
),
DateDiffDays(
[Issue].CurrentMember.get(‘Created at’),
[Issue].CurrentMember.get(‘Resolved at’)
)
-
(
[Measures].[Days in transition status],
[Transition Status].[Draft]
)
-
([Measures].[Days in transition status],
[Transition Status].[Live])
)
)
This works most of the time however there are some tickets that have been transitioned from draft back to draft as per the below example and for some reason this time isn’t being deducted. I tried add on to the deduction the specific transition ‘Draft to draft’ but this caused problems and led to minus figures in the results.
Any help would be apreciated!
Many Thanks
Carly