Cluster right and wrong Process

Hey community

I’d like to create a cluster in form of a OLAP table in Celonis in which I can select the right process, but also those ID’s that go wrong through the process.

for example:
image

I have problems with the coding :frowning:

Now something about the Process:

My process looks like f.ex.
Activity A Start–>Activity B -->Activity C -->Activity D -->Activity E–>Activity F END

For our department activity C and activity E is important. The other activities can be neglected.

The right process is when activity C comes first and activity E comes later, not the other way around.

The wrong process is,…

  1. when activity E comes first and activity C comes later, exactly the wrong way round,
  2. if activity E is completely missing,

I think I need something like this, but it is not yet thought through to the end

DISTINCT(CASE
WHEN PROCESS EQUALS ‘Activity C’ TO ANY TO ‘Activity E’ --the order is still missing here
THEN ‘right process’
WHEN MATCH_ACTIVITIES(NODE[‘Activity C’] EXCLUDING[‘Activity E’])
OR PROCESS EQUALS ‘Activity E’ TO ANY TO ‘Activity C’ --the order is still missing here
THEN ‘wrong process’
ELSE ‘’ END)

can anyone help?

Hi,

thanks for the detailed description. Can you please try following code:

CASE
WHEN
PROCESS EQUALS ‘Activity C’ TO ANY TO ‘Activity E’
AND PROCESS NOT EQUALS ‘Create Invoice’ TO ANY TO ‘Activity C’
THEN ‘Right Process’
WHEN
PROCESS EQUALS ‘Activity E’ TO ANY TO ‘Activity C’
OR PROCESS NOT EQUALS ‘Activity E’
THEN ‘Wrong Process’
ELSE NULL END

Best,
Viana