Percentage of variant with one case

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

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

Is it possible to do something like it on Celonis ? 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: 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

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 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