Hi Alejandro,

Here is an idea to get started with, use the VARIANT function to get different activities available in the process flow. VARIANT aggregates all activities of a case into a string.

You can take a distinct count of these variants

COUNT( DISTINCT (VARIANT (  "ACTIVITIESTABLE"."ACTIVITY") ))

You can also reduce any activity loop that may occur (which I understand is not your use case)

 COUNT( DISTINCT SHORTENED (VARIANT (  "ACTIVITIESTABLE"."ACTIVITY"),1 ))

You can go through the following article for more information

https://docs.celonis.com/en/variant.html

Thank you very much.

I appreciate the response time.

Best regards.