Hello,
I am working on one report in which I want to pull Average of Child Issues Associated with Epic (Average at Epic Level) of In Progress to Resolution time, Assigned to Resolution time. I have written the below measure but it is not working -
(NonZero(
Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Assigned Date]>0
)
,
[Measures].[Time Difference (Assigned to resolution)]
)))2460
Measure Time Difference (Assigned to resolution) -
DateDiffDays([Measures].[Assigned Date],[Measures].[Resolution Time stamp])
Can anyone please suggest me on this.
Thanks