Adding a rework filter - Celonis Snap

Question

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!

david.beche12 · Answer

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 KBCheersDavid

Sign up

Login with SSO

Login to the community

Login with SSO