Question
Count Variants by company code
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
I solved my issue with this formule:
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
Best regards,
Viana
+2Hi 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
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
I am working on the version 4.5.
Thanks
LauraReply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.