Rework analyses

Hi,

I would want to create an analyses where the user would be able to see how much rework (%) happened in a process, taking into account every Case ID separately
This would translate in a KPI which would check all the existing process steps which are happening more than once in a process and divide them with all the existing process steps (starting with the 1st step of the process and finishing with the last one)
Could you please advise me if this is possible and how could be done?

Thank you in advance and wish you a good day!

Hi,

for counting the process steps that occur more than once within a case you can use the PQL function ACTIVATION_COUNT which counts the rework activities and the PU function for relating the calculation for each case.

PU_COUNT("CASE_TABLE", "_CEL_XX_ACTIVITIES"."ACTIVITY_EN",ACTIVATION_COUNT("_CEL_XX_ACTIVITIES"."ACTIVITY_EN") > 1)/
PU_COUNT("CASE_TABLE","_CEL_XX_ACTIVITIES"."ACTIVITY_EN")

Best regards,
Viana