Question
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. Im just learning to use celonis:)
Regards,
Masha
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.