Continuing the discussion from Greetings!:
I’m new to Celonis and i have a requirement in building an analysis. Below specified is the requirement.
I have configured a Button drop down and it display all the Activites list. I created a variable (’<%= ACTIVITY_GROUP_1 %>’) to save the selection from the dropdown. I want to calculate the selected Activity count.
Below is the formula i’m using to get the count and it giving me correct values only if i select a single Activity. When i select multiple Activities i can see the variable having all the selected Activities seperated by comma(,) but the result is 0.
Can someone help me in getting the count of multiple Activities, and below is the formula i’m using.
PU_COUNT(“CASE_TABLE”, “_CEL_AP_ACTIVITIES”.“ACTIVITY_EN”,"_CEL_AP_ACTIVITIES".“ACTIVITY_EN” IN ( ‘<%= ACTIVITY_GROUP_1 %>’)))
Thanks & Regards,