Hey community
Id like to create a cluster in form of a OLAP table in Celonis in which I can select the right process, but also those IDs that go wrong through the process.
for example:
I have problems with the coding
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,
- when activity E comes first and activity C comes later, exactly the wrong way round,
- 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?
