Percentage of variant with one case

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

Hi,

I’m 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:
image

Laura

Is it possible to do something like it on Celonis ?

Thanks
Laura

Hi Laura,

it’s possible to do these KPI’s in Celonis.
For the KPI "# PO’s 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

1 Like

Hi Viana,

Thank you!
The 2 last formulas (# variants & % variants) are working, but for the # PO per variant, I have an error:

Seems missing a function.

Laura

Hi,

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 haven’t applied any filters)

Best
Laura

Sorry I didn’t 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:

Best
Laura