Total closed workdays

Questions & Answers
4

Hi,

There is no standard measure in eazyBI giving the number of the workdays for Issue till closing. The solution is to create the custom measure using the “DateDiffWorkdays” function:

DateDiffWorkdays(
  [Issue].CurrentMember.Getdate("Created at"),
  [Issue].CurrentMember.GetDate("Closed at")
)

Note also that this formula works with the Issue dimension when expanded at the Issue level. For the consolidated data you need to generate the set and sum the values of closed issues:

Sum(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues closed]>0
  ),
  DateDiffWorkdays(
    [Issue].CurrentMember.Getdate("Created at"),
    [Issue].CurrentMember.GetDate("Closed at")
  )    
)

Kindly,
Janis, eazyBI support

1 Like