Skip to main content
Hi everyone,
Im trying to add a rework filter to my analysis that allows the user to choose between activities and how often they occur.
Im thinking about something like this:
select cases where activity occurs more/less than 1/2/3 etc.
In that way we could filter down exactly onto those cases where Celonis identified rework.
I just started with Celonis, so Im not sure how to start/implement such a filter so I hope I could get some help from the Celonis Community.
Thank you very much in advance!
Hi Alina,
welcome to the Celonis Community!
In general you can set a rework filter (as a component or sheet filter) with this:
FILTER CALC_REWORK( "Activities"."Activity" = 'X' ) > 3;
This would filter on all Cases where Activity X is contained more than 3 times.
You can make this customizable to the user by adding dropdown components or text inputs to write the user inputs to variables. You can replace the respective parts of the query with those variables:
FILTER CALC_REWORK( "Activities"."Activity" = '<%=activity%>' ) <%=comparison%> <%=number%>;
Alternatively, you can use the REWORK selection:
image2549558 94.3 KB
Cheers
David
Hi David,
thank you very much for your help! Its highly appreciated and solved the problem I was facing!
Thanks,
Alina

Reply