Count of Issues created from yesterday 6pm to today 6pm

Questions & Answers
1

Hi Team,

I want to know the issues created between yesterday 6pm to today 6pm.

I tried it adding filter the time between yesterday 6pm, today 6pm by referring below link, but couldn’t succeeded.

Can you please help on this.

Regards
Kasi

2

Hi,

We already discussed this question directly in support emails. The following is a summary.

The first option is creating a custom measure with the following code that would filter out issues resolved yesterday after 6 pm or resolved today before 6 pm, and then sum them up:

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
   (DateInPeriod([Issue].CurrentHierarchyMember.get('Created at'), [Time].[Day].CurrentDateMember.PrevMember)
    and
    Hour(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) >= 18)
    OR
   (DateInPeriod([Issue].CurrentHierarchyMember.get('Created at'), [Time].[Day].CurrentDateMember)
    and
    Hour(DateParse([Issue].CurrentHierarchyMember.get('Created at'))) <= 18)),
  [Measures].[Issues created]
)

This calculation is not fast, as it iterates through all issues. For larger instances, calculated JavaScript custom field that returns a value in what part of the day the issue is created - “after 6pm” and “before 6pm” for each issue - and imported as a dimension would help: JavaScript calculated custom fields - eazyBI for Jira

Best
Ilze / support@eazybi.com

1 Like