Count of open tickets by the end of a time period (Only if created in this same period)

Questions & Answers
1

Hi there,
I need to count the following KPI and cannot find a solution for it:

  • From the amount of tickets that were created in a particular time period, how many of these were still open by the end of this time period. As far as I understand the calculated measure “Open Issues” can not be used here, because it will count also open tickets that were created in previous time periods.

Thanks in advance!

2

Anyone has an idea how to solve it?

Thanks!

3

Hi,

The following formula should do that:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    (IsEmpty([Measures].[Issue resolution date])
    OR
    DateAfterPeriodEnd([Measures].[Issue resolution date],
    [Time].CurrentHierarchyMember))
    AND
    [Measures].[Issues created]>0    
  )
))

This approach, however, could have performance risks. A more efficient solution could be possible with a Javascript calculated custom field:
https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields

Kindly,
Janis, eazyBI support