I would like to create a KPI that counts the cases, where some ACTIVITY1 is NOT followed by ACTIVITY2 or by ACTIVITY3.
Let’s says it is like in the court: there is a case upon which it sould be decided (ACTIVITY 1 would be ‘The case is on the table of the judge’). The decision is either YES or NO and I want to know how many cases are still awaiting a decision. I can’t really use the COUNT(PU_LAST(TABLE, MATCH_ACTIVITIES(ENDING[‘ACTIVITY1’] ) =1)) bacause it some events in between can happen, for example the judge would like an assistant to get some additional info to make a decision, while the case is still on her/his table. Any ideas?