CASE WHEN for multiple conditions

Hi team,

i am trying to write a CASE WHEN statement for a process explorer to show only the activities that satisfy a dropdown filter based on multiple selections.

Sample dataset:
(Case ID, Activity, Source,…)
Case1, Activity 1, Screen1,…
Case1, Activity 2, Screen1,…
Case1, Activity 3, Screen2,…
Case2, Activity 2, Screen1,…
Case2, Activity 4, Screen1,…
Case1, Activity 5, Screen3

I would like to be able to filter in a custom process explorer the activities only from a particular screen (e.g. filter dropdown: Screen1 and Screen 3–> only Activities 1, 2, 4 and 5 are shown on the process explorer).

My current query doesn’t allow me to select multiple conditions, and doesn’t work with the ‘IN’ function as well:

CASE WHEN “BOOKS_USER_05JUN”.“SOURCE” LIKE <%=Source_Process%> THEN “BOOKS_USER_05JUN”.“ACTIVITY” ELSE NULL END

Best,
Dominic

Hi Domenic,

what should work is a Component Filter in the process explorer with a defined variable:

FILTER "BOOKS_USER_05JUN"."SOURCE" IN (<%=yourvariable%>);

Then you can let a button dropdown choose the Screen values and write it to the above defined variable.
This should lead to only the activities for the respective Source type.

Best regards,

Celonis Data Science Team

Hi Team,

If my Button Drop Down is a combination of Code + Name, How do I filter the Process Explorer using Component Filter for the respective Code + Name?

This does not seem to work:
FILTER (“TableName1”.“Col” || ‘-’ || “TableName2”.“Column”) IN (<%=yourvariablee%>);

Regards,
Sukhanya

Hey Sukhanya,

Sometimes I have problems with the Process Explorer and filters as well. That´s why I always choose the custom dimension option in the Process Explorer. Then you could build your own CASE statement for the Activities.

I guess your solution could look something like this:

CASE
    WHEN (“TableName1”.“Col” || ‘-’ || “TableName2”.“Column”) IN (<%=yourvariablee%>)
    THEN "Activities"."Activity_en"
    ELSE NULL
END

In this way all other activities are excluded from the process explorer.

Best regards