Count issues created at certain period of hours of the day

Questions & Answers
6

Hi @Josef.Wagner

I missed that the Tips&Tricks section of the community site has an example that I could have pointed you toward - Issues created out of office hours. See the last part of the first post.

But the calculated measure formula for the period 7:30-11:30 could look similar to the one below:

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    (
      Hour(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) > 7
      OR
      Hour(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) = 7
      AND
      Minute(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) >= 30
    )
    AND
    (
      Hour(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) < 11
      OR
      Hour(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) = 11
      AND
      Minute(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) <= 30
    )
  ),[Measures].[Issues created]
)

Best,
Roberts // support@eazybi.com