Good morning, I am using this calculated measure, “Average Resolution Days from InProgress to Done” and I would like to know if is possible to remove the Epic’s from this equation.
Avg(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues resolved]>0
),
DateDiffDays(
([Measures].[Transition to status first date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember),
([Measures].[Transition to status last date],
[Transition Status].[Decline and Done statuses],
[Time].CurrentHierarchy.DefaultMember)
)
)
Thank you
Hi, @Sara_Chaves
To exclude the Epics from Average Resolution days you need to add criteria to your calculation:
AND [Measures].[Issue type] <> "Epic"
So, full calculation will look like this:
Avg(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues resolved]>0
--& Issue type is not Epic
AND [Measures].[Issue type] <> "Epic"
),
--Number of days from "In Progress" to "Decline" or "Done"
DateDiffDays(
(
[Measures].[Transition to status first date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember
),
([Measures].[Transition to status last date],
[Transition Status].[Decline and Done statuses],
[Time].CurrentHierarchy.DefaultMember)
)
)
Best regards,
Ilze Mezīte support@eazybi.com