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

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!

Anyone has an idea how to solve it?



The following formula should do that:

    (IsEmpty([Measures].[Issue resolution date])
    DateAfterPeriodEnd([Measures].[Issue resolution date],
    [Measures].[Issues created]>0    

This approach, however, could have performance risks. A more efficient solution could be possible with a Javascript calculated custom field:

Janis, eazyBI support