Adding a rework filter - Celonis Snap

Hi everyone,
I’m trying to add a rework filter to my analysis that allows the user to choose between activities and how often they occur.

I’m 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 I’m 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! :slight_smile:

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:

Cheers
David

Hi David,

thank you very much for your help! It’s highly appreciated and solved the problem I was facing!

Thanks,
Alina