Epic resolution time based on underlying stories

Questions & Answers
1

Hello there,

I would like to create a report that counts the number of days each Epic was being implemented. This means the first transition of either of the Stories under an Epic till the resolution of all.

The closest thing I was able to look up was the resolution time of items, but I failed to adapt it to my needs:

NonZero(
  Avg(
    Filter(
      Descendants([Issue].CurrentHierarchyMember,[Issue].[Story]),
      (
        [Measures].[Transitions to status],
        [Transition Status].[Done (TT)]
      )>0
    ),
    DateDiffDays(
      (
        [Measures].[Transition to status first date],
        [Transition Status].[To Do (TT)],
        [Time].CurrentHierarchy.DefaultMember
      ),
      (
        [Measures].[Transition to status last date],
        [Transition Status].[Done (TT)]
      ) 
    )
  )
)

Any help or hint is highly appreciated.

Thanks
Szabolcs

2

Hi @zsszabolcs ,
You are close to the solution, but you need to use the correct hierarchy ([Issue.Epic]) and level ([Issue.Epic].[Epic]) in the Descendants() function:

NonZero(
  Avg(
    Filter(
      Descendants([Issue.Epic].CurrentHierarchyMember,[Issue.Epic].[Epic]),
      (
-- rest of your formula

Kind regards,
Gerda // support@eazyBI.com