Currently I have a table where I list all my process activities, where one of the KPI’s is a calculation of the ratio of cases where a given activity is present.
The calculation I’m making to get this is the following:
I would then like to filter this table, so that it only shows me the activities that have a ratio of less than 1%. However, Celonis does not allow to filter on aggregate functions.
I’ve tried other workarounds, unsuccessfully.
Is there a way for me to accomplish this and show only the desired activities?
Thanks in advance for your help,