Skip to main content
The ACTIVATION_COUNT operator returns for every activity in every case, how many times, at a given point in a process this activity has already occurred. Is there a similar function that counts how many times the activity occurred for every case? 2020-09-01 14_46_43-11 AP First Time Right _ Process Analytics780228 5.03 KB 2020-09-01 14_46_35-11 AP First Time Right _ Process Analytics803138 2.45 KB E.g. in this case, I used ACTIVATION_COUNT for the repetitions. Now the #2 is actually the total number of cases, as it means 2x at this point but it might be more. Is there a way to show when the activity happened exactly 2x (so exclude 3x, 4x, etc.) Thanks!
Hi @rita.kiss, thanks for reaching out! INFO: Note that ACTIVATION_COUNT is deprecated. Please use INDEX_ACTIVITY_TYPE instead in the future. I have replicated your scenario with a demo model. You can use CALC_REWORK to get the correct result: image870354 3.97 KB In this case, the PQL of my # Repititions KPI is as follows: CALC_REWORK ( "_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN" IN ('Change Quantity') ) Please try this formula and see if it fits your needs. Best regards, Data Science Team
Hi Data Science Team, Thanks! As I have all the change activities in the table (not just one, I included a filtered to one activity in the screenshot), the CALC_REWORK cannot have a filter to just one specific change activity - and without the filter, it just counts all the activities for the case, not just the one mentioned in the row - this solution doesnt work. I will implement as a workaround together with a filter. Any other options I might try to show the whole table? (I tried to use INDEX_ACTIVITY_TYPE but it gives me an invalid operator error. I assume because we use on-premise and not IBC.) Thank you and kind regards!