Rework selection is not working?

Hi everyone.
I am confused by the following case: I use the rework selection filter as below:

image.
However the results that i get still contain cases with just one revision:
image
I would suppose my code behind the KPI is wrong:

SUM(CASE WHEN PU_COUNT(“CEL_LBU_CASES”, “CEL_LBU_ACTIVITIES”.“ACTIVITY_DE”, “CEL_LBU_ACTIVITIES”.“ACTIVITY_DE” = ‘Revision’)>=2 THEN 1.0 ELSE 0.0 END)
/
SUM(CASE WHEN PROCESS EQUALS ‘Revision’ THEN 1.0 ELSE 0.0 END)

But the case explorer also shows the cases with only one revision.

image

and

image

Thank you!

Hi DrWindy,

In certain Celonis versions there is an issue with the rework selection, where it will actually match every activity that contains a substring of your query.
In your case, both “Revision” and “Revisionsfreigabe” will be counted, which causes your example case to show up.

We have not encountered this in release 4.5, so upgrading your installation should fix that.

However, depending on your process, there might be a quicker fix. If every “Revision” is followed by a “Revisionsfreigabe”, you can adjust your threshold as follows:

  • = 2 Revision --> > 2 Revision (Revision, Revisionsfreigabe, Revision)

  • = 3 Revision --> > 5 Revision (R, RF, R, RF, R)

Basically, you replace your threshold by (2*threshold)-1 in Celonis.

Best regards,
Viana

2 Likes

Hello Viana,

thank you for the explanation. We’re installing 4.5 in the nearest future, so the Problem is solved i guess.

Best,

Maria