Issues created out of office hours

[martins.vanags]

@pbenati

It must be the same timezone as provided in eazyBI import options page > Time zone section:
https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-Timedimension

And here you can find how to change the cell color:
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/conditional-cell-formatting

Martins / eazyBI

[pbenati]

Martins,

Thanks! I appreciate all of you assistance via this thread!! Here’s my output…

[steinerw]

@martins.vanags

NonZero([Measures].[Issues created] - -- total created issues minus created during working h
Count(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  DateInPeriod(
    [Issue].CurrentMember.get('Created at'),
    [Time].CurrentHierarchyMember) AND -- created date in the period
  [Measures].[Issues created] > 0 AND -- issue is created in selected report context
  ((Hour(DateParse([Issue].CurrentMember.get('Created at'))) >= 9 AND -- created hour is after 9
    Hour(DateParse([Issue].CurrentMember.get('Created at'))) < 17 -- created before 17
  ) OR (
    Hour(DateParse([Issue].CurrentMember.get('Created at'))) = 17 AND -- if the hour is 17
    Minute(DateParse([Issue].CurrentMember.get('Created at'))) < 30 -- then created is before 17:30
  ))
)))

How should I change the Code to get only Tickets created between 7:30 am and 8:00 am `?

I set the Filter of last 60 days and need to know how many issues was created in this time period from 7:30am to 8:00am

[martins.vanags]

Hi @steinerw

You could try asking such questions to MDX formula asssitant.

MDX Formula Assistant - AI Assistants

Try this code:

NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      DateInPeriod(
        [Issue].CurrentMember.Get('Created at'),
        [Time].CurrentHierarchyMember
      )
      AND
      (
        (
          Hour(DateParse([Issue].CurrentMember.Get('Created at'))) = 7
          AND Minute(DateParse([Issue].CurrentMember.Get('Created at'))) >= 30
        )
        OR
        (
          Hour(DateParse([Issue].CurrentMember.Get('Created at'))) = 8
          AND Minute(DateParse([Issue].CurrentMember.Get('Created at'))) = 0
        )
      )
      AND
      [Measures].[Issues created] > 0
    )
  )
)

Martins