Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Hi Louis,

That should be possible. The conformance query calculates per Activity if it is conform or not as described here: https://docs.celonis.com/en/conformance.html#idm45713625564912.

Your use case is described here in example 3:

• First you calculate the conformance per Case, by using a PU_SUM of the absolute conformance score per activity. I would advise to return a 1 for conform cases and a 0 for non-conform cases.
• Now you have 1 and 0 per case, you can just add an AVG operator, to calculate the ratio of conform cases.

I hope this helps!

Best regards,

Jan-peter

i thought about this as well, but it always says "Syntax error near [.] after reading [ AVG (CASE WHEN PU_SUM ("_CEL_O2C_ACTIVITIES"] at line 2. Please refer to PQL documentation for available syntax", my code is "AVG (CASE WHEN PU_SUM ("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN", ABS (<%= conformanceKPIAm %>)) = 0 THEN 1 ELSE 0 END)" in the variable is the conformance query, and the activity table of the query is "_CEL_O2C_ACTIVITIES"

Hi @Louis Forster,

There is indeed a syntax error. The first entry of the PU_SUM() function should be the table name where you want to pull your data to. Since you want a sum per case, this is likely to be your case table.

If you do not have a case table, you could use the CASE_KEY column of your activity table for this. Please fill in 'DOMAIN TABLE( "_CEL_O2C_ACTIVITIES"."<<CASE KEY COLUMN HERE>>") in the case table place holder below.

Your code will be:

"AVG (CASE WHEN PU_SUM ("<< CASE TABLE HERE >>", ABS (<%= conformanceKPIAm %>)) = 0 THEN 1 ELSE 0 END)"

I hope this helps!

Best regards,

Jan-peter

Hi Jan, thanks in general for your help. Even when i use it

"AVG (CASE WHEN PU_SUM (DOMAIN TABLE("_CEL_O2C_ACTIVITIES"."_CASE_KEY", ABS (<%= conformanceKPIAm %>)) = 0 THEN 1 ELSE 0 END)"

i still have a message error

"Syntax error near [DOMAIN] after reading [ AVG (CASE WHEN PU_SUM (] at line 2. Please refer to PQL documentation for available syntax."

Do you know a potential error source, thanks in advance :).

Best regards, Louis Forster

Hi Jan, it works :), such a big thank you. Have a nice Day. Best regards Louis

Good to hear, happy to help!