Skip to main content
Solved

Hello, I would like to know if its possible to get a count of all the flows that are in total in the whole Process explorer. (Including all reworks and cases flows). To show it in a Card.

  • November 4, 2022
  • 2 replies
  • 8 views
R
Level 4
Hello, I would like to know if its possible to get a count of all the flows that are in total in the whole Process explorer. (Including all reworks and cases flows). To show it in a Card.

Best answer by abhishek.chatu14

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

    2 replies

    abhishek.chatu14
    Level 11
    Forum|alt.badge.img+4

    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

    R
    Level 4
    • raul.rodri12
    • Author
    • Level 4
    • November 8, 2022

    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.

     

    Community Code of ConductAccessibility statement