Calculate defect fix duration for defect created within a time frame

Questions & Answers
1

Hello, I am able to calculate the total closure duration for a set of defects created in a timeframe. However, the same calculation does NOT work when I try to calculate total fix duration. Please help.

Total Closure Duration
CASE WHEN
(
[Measures].[Transitions to status],
[Issue Type].[Bug],
[Label].[ColleagueServices],
[Transition Status].[Re-test]
) > 0
THEN
SUM(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember)
AND [Measures].[Issue type] = ‘Bug’
AND [Measures].[Issue labels] = ‘colleague_services’
),
DateDiffDays(
(
[Measures].[Issue created date]
),
(
[Measures].[Issue closed date]
)
)
)
END

Total Fix Duration
CASE WHEN
(
[Measures].[Transitions to status],
[Issue Type].[Bug],
[Label].[ColleagueServices],
[Transition Status].[Re-test]
) > 0
THEN
SUM(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember)
AND [Measures].[Issue type] = ‘Bug’
AND [Measures].[Issue labels] = ‘colleague_services’
),
[Measures].[Fix Duration]
)
END

Fix Duration
DateDiffDays(
[Measures].[Issue created date],
[Measures].[Last Transition to Retest])

Last Transition to Retest
([Measures].[Transition to status last date],
[Transition Status].[Re-test])

2

Hi @ranjandutta

You’re on the right track!

However, the issue with the last formula is that the last transition gets filtered by the Time selection in Pages and may not return a value if there is no transition in that period.

Please try the following formula for the Last Transition to Retest measure:

([Measures].[Transition to status last date],
[Transition Status].[Re-test],
[Time].CurrentHierarchy.DefaultMember)

​Best regards,
​Nauris

3

Thanks a lot @nauris.malitis. It worked like a charm. You made my day.

1 Like