Calculate Hours Spent in Transition Status for on Epic childrens

Questions & Answers
,
1

Hi There,

I am trying to build the below report:

image
image1127×170 5.08 KB

Unfortunately without a success.

Could you please guide me to make it working correctly?

I tried with many custom measures but the recent one is as follows (for the specific Transation Status):

Sum(
  Filter(
    Descendants([Time].CurrentHierarchyMember,[Time].CurrentHierarchy.Levels("Day")),
    DateBetween(
      [Time].CurrentHierarchyMember.StartDate,
      ([Transition Status].[In Design],[Issue Type].[Epic],[Measures].[Transition to status first date]),
      ([Transition Status].[In Design],[Issue Type].[Epic],[Measures].[Transition from status last date])
    )
  ),
  ([Measures].[Hours spent],[Logged by].CurrentMember)
)

Thanks in advance for your support.

2

Hi @matiu91

Welcome to the Community! :100:

Did you try using the default dimension members and the predefined “Hours spent” measure from the Measures dimension?

loggedby-hoursspent
loggedby-hoursspent1802×1624 353 KB

Or are the default members/measures not returning any results?
Did you try to build the same report without the Issue dimension in Rows? This way you could check if the Hours spent are successfully imported for the users.

Looking forward to sorting this out!
​Best regards,
​Nauris / eazyBI support