Time in Status in Days/Hours format

Questions & Answers
1

Hello dears,

We have this script here that brings us back in Status including current:

– -Workdays in transition status when issue was in this status in previous times
IIF(
– if report uses Status dimension instead of Transition status it should work as well:
[Status].CurrentHierarchyMember.Level.Name = “Status” and Not [Transition Status].CurrentHierarchyMember.Level.name = “Transition status”,
([Measures].[Workdays in transition status],
[Transition Status].[Transition status].GetMemberByKey(
[Status].CurrentHierarchyMember.Key
)),
[Measures].[Workdays in transition status])
+
– days since last transition to this status
NonZero(SUM(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
– for unresovled issues only
IsEmpty([Issue].CurrentHierarchyMember.Get(“Resolved at”))
AND
IIF([Transition status].CurrentHierarchyMember.Level.Name = “Transition status”,
[Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
AND
IIF([Status].CurrentHierarchyMember.Level.Name = “Status”,
[Status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
),
CASE WHEN
[Measures].[Issues history] > 0
THEN
DateDiffWorkdays(
[Measures].[Issue status updated date],
Now()
)
END
))

Can we get this same metric in days/hours format?

That would help me a lot!

Thank you very much in advance!

1 Like
2

Hi @DEGAN

You can define a new calculated measure and multiply this existing measure by 24 and by 60:

[Measures].[Days in transition status till now] * 24 * 60

For this measure, choose Formatting → Duration → Days, hours, minutes.
The result should be as follows:

worktime
worktime698×434 38.7 KB

Note that the standard “Workdays in transition status” measures the total amount of time spent in a Transition status. This means that the new measure will also show the total days, hours and minutes between statuses and not just the business hours.

Best regards,
Nauris / eazyBI support

1 Like