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 doesnt allow me to select multiple conditions, and doesnt 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

Page 1 / 1

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. Thats 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

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN