Hi Zeliha,

by adding the comformance Sheet and creating or uploading your Process Model, celonis will generate automatically the comformance Ratio for you

Hello Laamouri Rashid,

thanks for your answer.

Our aim is to show conformance ratio in KPI Component that is why we try to discover the pql code.

maybe try this function:

MATCH_ACTIVITIES(( activity_table.string_column, ] STARTING activity_list ] , ] NODE activity_list ] , ] NODE_ANY activity_list ] , ] ENDING activity_list ] , ] EXCLUDING activity_list ] , ] EXCLUDING_ALL activity_list ])

or

MATCH_PROCESS ( activity_table.string_column ,] node (, node)* CONNECTED BY edge (, edge)* )

in combination with sum (Case When MATCH_ACTIVITIES(..) = 1 THEN 1 ELSE 0 END) / count_Table(Case_Table)

I hope that helps :)

Hello Rashid,

many thanks for your answer. Lastly, what if we have some process flows in the allowlist?

How could we implement this?

Hello Zeliha,

you can add the allowlist manually as an additional condition(s) to the case when Statment:

Case When MATCH_ACTIVITIES(..) = 1  AND allowlist1 and ...