Drop down/filter by attribute of a specific activity

Hi everyone,

I need to create a drop down that will allow me to filter cases shown in the analysis by the value of a specific attribute of a specific activity.

In particular: I need to filter cases where activity ‘remove billing block’ was performed either by user type A or B.

Process O2C in SAP, if that is important.

Thank you very much in advance

Regards
Masha

Hi Masha,

my approach would be the following:

CASE WHEN “ACTIVITY_TABLE”.“ACTIVITY_EN” IN (‘remove billing block’)

THEN CASE WHEN “ACTIVITY_TABLE”.“USER_TYPE” =‘A’ THEN ‘USER TYPE A’
WHEN “ACTIVITY_TABLE”.“USER_TYPE” =‘B’ THEN ‘USER TYPE B’
ELSE ‘USER TYPE NOT KNOWN’
END

END

This PQL-Formula selects the cases where the activity ‘remove billing block’ is part of the process. After selecting these cases, the PQL-Formula then checks the user type and adds a dropdown option accordingly.

Best regards,
Data Science Team

Thanks a lot!

I actually already solved this one like this:

CASE WHEN “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” LIKE ‘remove billing block’
THEN “_CEL_O2C_ACTIVITIES”.“USER_TYPE”
ELSE ‘not relevant’ END

But thanks for your response anyway, it helped me to verify that I found the right solution. I’m just learning to use celonis:)

Regards,
Masha