The options available for the same are PU_Functions and Bind

https://docs.celonis.com/en/bind.html#idp612421

Hello Abhishek,

thanks for your input: I have checked the link you shared and the examples described, but I was not able to find a correspondence with what I need to perform.

The concurrent usage of PU Functions and BIND is useful to aggregate data over tables with a 1:N:1 relationship, like in the image below (screenshot taken from official documentation):

My situation with multi-value attributes involves an N:1:M relationship between the involved tables, as in the schema below:

The goal I would like to achieve is being able to create a dropdown filter based on the muti-value attribute (the color in this example) and then calculate the Average Throughput Time based on the cases which fall in the color selection.

In the example above, if I select in the dropdown the values uRed, Yellow], this will imply the selection of Case 1 only, and then the Average TPT should be 15 days (from 10/8 to 25/8).

On the other hand, if I select in the dropdown the values uRed, Yellow, Pink] or Red, Orange], this will imply the selection of both cases, and then the Average TPT should be 10.5 days (average between 15 days of case1 and 6 days of case2).

I can't figure out how I can achieve this result using PU Functions and Bind.

Can you please elaborate a little bit more? Any suggestions will be highly appreciated.

Thanks very much, best regards,

Andrea