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],
Janis, eazyBI support