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.