Hello,
I would like to create a table with a count of variants by Company Code but when I use the standard KPI Number of process variants, the number not corresponding to the total I have on the Variant Explorer.
Is it exist a simple formule to count the variants?
Thank you
Page 1 / 1
I solved my issue with this formule:
COUNT ( DISTINCT SHORTENED(VARIANT(("_CEL_ACTIVITIES".ACTIVITY_EN))))
COUNT ( DISTINCT SHORTENED(VARIANT(("_CEL_ACTIVITIES".ACTIVITY_EN))))
Hi Laura,
exactly, the formula you have used is the one I would have suggested too
Best regards,
Viana
exactly, the formula you have used is the one I would have suggested too
Best regards,
Viana
Hi Laura,
I wonder why you get different results, as this is exactly the formula which is behind the Number of Process Variants KPI.
Can you please check again if you get different numbers by putting both formulas (the one you wrote and the predefined standard KPI) next to each other in an OLAP table?
Which version of Celonis (IBC, CPM4.5, ) are you using?
Thanks for your help and best regards
David
I wonder why you get different results, as this is exactly the formula which is behind the Number of Process Variants KPI.
Can you please check again if you get different numbers by putting both formulas (the one you wrote and the predefined standard KPI) next to each other in an OLAP table?
Which version of Celonis (IBC, CPM4.5, ) are you using?
Thanks for your help and best regards
David
Hi David,
Bellow you can see the OLAP with in the first column the formule and the second one the standard KPI:
I am working on the version 4.5.
Thanks
Laura
Bellow you can see the OLAP with in the first column the formule and the second one the standard KPI:
I am working on the version 4.5.
Thanks
Laura
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.