Hi ,
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.
Sum(
– get set of dates between Reopen and closed dates
Filter(
[Time].[Day].Members,
DateBetween(
[Time].CurrentHierarchyMember.StartDate,
[Measures].[Issue Reopened Date],
[Measures].[Date Issue Closed Again])
),
– sum up spent hours on those dates
– [Measures].[Hours spent]
[Measures].[Hours spent]
)
Could anyone please provide me a good solution to calculate hours spent between two dates.