The standard ratio count does not work because it takes into account the activities and not the cases.
I have tried: filter count (which does not work because it counts activity and not the cases)
I tried multiple PU_count and PU_count_distinct (also did not work)
I have tried case when (activity = "XX") then count (cases) else 0. (But this is not allowed in Celonis)
The syntax you are looking for is as follows
SUM(Case when activity = "XX" then 1 else 0 end )
This would give you of a summation of all the rows where the activity is present.
Now since you want to take the count of distinct case here is what that would look like
COUNT ( DISTINCT Case when activity = "XX" then case_table.casekey end )
In this case you are looking at unique case keys that give you the desired output.
Hi Gabriella,
You should also be able to use PROCESS EQUALS, so:
SUM(CASE WHEN PROCESS # 'Your Activity' THEN 1 ELSE 0 END)
Hope this helps,
Marcel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
