Skip to main content
Question

Drop down/filter by attribute of a specific activity

  • July 16, 2020
  • 2 replies
  • 32 views
M
Level 5
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

2 replies

C
Level 0
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
M
Level 5
  • masha.galit
  • Author
  • Level 5
  • July 29, 2020
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
Community Code of ConductAccessibility statement