Need to get Activity count for the selected Activities (multiple) from Button Drop down

Continuing the discussion from Greetings!:

Hi

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.

SUM(
PU_COUNT(“CASE_TABLE”, “_CEL_AP_ACTIVITIES”.“ACTIVITY_EN”,"_CEL_AP_ACTIVITIES".“ACTIVITY_EN” IN ( ‘<%= ACTIVITY_GROUP_1 %>’)))

Thanks & Regards,
Chanti

Hi Chanti,

In the Button drop down, please ensure the wrapping character fields have single inverted commas included. See below image.

image

Also, modify your code to remove those inverted commas where the variable name is placed.

SUM(
PU_COUNT(“CASE_TABLE”, “_CEL_AP_ACTIVITIES”.“ACTIVITY_EN”."_CEL_AP_ACTIVITIES".“ACTIVITY_EN” IN (<%=ACTIVITY_GROUP_1 %>)))

Lastly, this may not give you an error, but not 100% sure if your function will give the correct answer either. But I won’t be able to confirm or suggest otherwise without knowing more about the final analysis’s objective you are trying to create.

2 Likes

Hi Newlen,

Thanks for your prompt response and it solved my requirement.

Now i can able to get the count for the selected multiple activities.

Cheers!

Chanti