Hi all,
I would like to calculted the % of variant with 1 case, 2 cases, 3 cases, n cases
I tried with KPI(Number of process variants) but I have not the result I would like.
Thank you
Laura
Page 1 / 1
Hi,
Im not quite sure if I understood you correctly. Can you please explain what you would liek to achieve in more detail?
Thanks and best regards,
Viana
Im not quite sure if I understood you correctly. Can you please explain what you would liek to achieve in more detail?
Thanks and best regards,
Viana
Hi Viana,
The client noted a lot of variant of the process are following but 1 case.
For us, this would mean that a lot of PO items have not been well planned so to understand the type of order used and if the variant is justified or not, they would like to know the percentage of variant with 1 case, 2 case , n cases ect. to analyse them together.
For exemple:
Laura
The client noted a lot of variant of the process are following but 1 case.
For us, this would mean that a lot of PO items have not been well planned so to understand the type of order used and if the variant is justified or not, they would like to know the percentage of variant with 1 case, 2 case , n cases ect. to analyse them together.
For exemple:
Laura
Is it possible to do something like it on Celonis ?
Thanks
Laura
Thanks
Laura
Hi Laura,
its possible to do these KPIs in Celonis.
For the KPI "# POs per Variant " you would have to configure following PQL formula:
KPI # Variants:
and for the KPI % Variants
Best regards,
Viana
its possible to do these KPIs in Celonis.
For the KPI "# POs per Variant " you would have to configure following PQL formula:
PU_COUNT(DOMAIN_TABLE(VARIANT("_CEL_XX_ACTIVITIES"."ACTIVITY_EN")), "CASE_TABLE"."_CASE_KEY")KPI # Variants:
COUNT(DISTINCT VARIANT("_CEL_XX_ACTIVITIES"."ACTIVITY_EN"))and for the KPI % Variants
COUNT(DISTINCT VARIANT("_CEL_XX_ACTIVITIES"."ACTIVITY_EN"))/ GLOBAL(COUNT(DISTINCT VARIANT("_CEL_XX_ACTIVITIES"."ACTIVITY_EN")))Best regards,
Viana
Hi Viana,
Thank you!
The 2 last formulas (# variants & % variants) are working, but for the # PO per variant, I have an error:
image913201 13.9 KB
Seems missing a function.
Laura
Thank you!
The 2 last formulas (# variants & % variants) are working, but for the # PO per variant, I have an error:
image913201 13.9 KB
Seems missing a function.
Laura
Hi,
can you try to use _CEL_P2P_ACTIVITES._CASE_KEY instead of CASE_TABLE."_CASE_KEY"?
Best,
Viana
can you try to use _CEL_P2P_ACTIVITES._CASE_KEY instead of CASE_TABLE."_CASE_KEY"?
Best,
Viana
Hi,
Then I no longer have an error message but I cannot reach 100%. (I havent applied any filters)
image819264 7.23 KB
Best
Laura
Then I no longer have an error message but I cannot reach 100%. (I havent applied any filters)
image819264 7.23 KB
Best
Laura
Sorry I didnt see that my table had a limit of 4 lines.
Howerver I can not find allvariants with 1 case as you could see on the screenshot:
image1137631 129 KB
Best
Laura
Howerver I can not find allvariants with 1 case as you could see on the screenshot:
image1137631 129 KB
Best
Laura
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.