Count of tickets where Days open is > 14 days

Questions & Answers
1

I am trying to create a bar chart where X-axis is month and y-axis is just a count of “How many tickets took longer than X to close” and “currently open for > x days”

Kind of “How many tickets failed or are failing SLA”

2

Hi,

The following formula is for counting issues that exceeded the resolution time by ten days or, for the open issues at the end of the month, it counts the issues that are open for more than ten days at the end of the period. For the current month, the unresolved issues are counted if those are open for more than ten days till now:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Total resolution days]>=10
    OR
    [Measures].[Open issues]>0
    AND
    DateDiffDays([Measures].[Issue created date],
      CASE WHEN
       DateInPeriod(Now(),[Time].CurrentHierarchyMember)
      THEN
        Now()
       ELSE
      [Time].CurrentHierarchyMember.NextStartDate
     END
    )>10
  )
))

Kindly,
Janis, eazyBI support