Good Day !!
I am working on the requirement of finding reopened (Transition : Closed => Reopened) tickets of projects.
and I want to calculate hours spent between Reopened date and date the ticket Closed again.
I am trying with following code and getting timeout error.
– get set of dates between Reopen and closed dates
[Measures].[Issue Reopened Date],
[Measures].[Date Issue Closed Again])
– sum up spent hours on those dates
– [Measures].[Hours spent]
Could anyone please provide me a good solution to calculate hours spent between two dates.
Is there any update on my query ?
I am sorry this question didn’t get any attention for so long.
This is a quite heavy calculation as it iterates through every day for each issue and that is the reason it times out.
Robert / eazyBI support
I made something which is similar.
Elapsed time (spent hours) since going Live (date of PROD)
Sum (Filter (
Descendants ([Time] .CurrentHierarchyMember, [Time]. [Day]),
DateBetween([Time].CurrentMember.StartDate,Format([Measures].[Profields date of PROD].Value, ‘mmm dd yyyy’),‘today’)
), [Measures]. [Hours spent])