Custom Process Connection and Activity KPI

Hi! I strongly assume that youre not too stupid to achieve that It is more about how the process explorer works and how it visualizes the connections. The connection is 100% because all of these cases who take this path are directly connected to the activity. For further support, can you please provide the PQL script that you are currently using? Best regards, Viana

Hey Viana, thank you very much for the reply. Unfortunately I do not have the PQL Script for that, but I want to have it Currently I am working with this formula within the process explorer KPI: COUNT_TABLE(EKPO) / GLOBAL(COUNT_TABLE(EKPO)) However, this is calculating the % of the global case counts and not from the preceding or subsequent activity respectively. My goal is to have use the case frequency of each activity and calculate the % of connections to all other subsequent activities. In the picture above, assume 60% flow from Create Sales Order Item to Create Delivery and other 20% flow to Goods Issue and the rest 20% flow to the end. How can I get the % values of each connection and not their absolute values? I hope you understand my problem. All the best

Hi lenlehm, The following will get you the number of distinct cases a connection was in as a proportion of the total number of cases: COUNT(DISTINCT SOURCE("_CEL_DEMO_ACTIVITIES"."case_key")) / COUNT("_CEL_DEMO_CASES"."case_key") Im not the best at TARGET/SOURCE relationships in Celonis, so heres another more detailed thread if this isnt working the way you expected or you want to learn more. Thanks, Kevin