Hello,
Im sorry about the late reply.
It is possible to replicate some to the KPIs of these sheets using other process functions. E.g. it could be calculated how many cases follow a certain process path using MATCH_PROCESS_REGEX().
If you explain to us which KPIs you are interested in, we can help you work out how to write the PQL code. Please include screenshots of the KPIs. If you want to replicate aspects of the conformance checker please send a screenshot of the BPMN model of the process.
Best wishes,
Calandra

---

Thanks Calandra for support here.
Example of the KPIs which we are looking for:

We would like to use this KPI in benchmarking for different units.

---

Which cases count as conforming depends on how the correct process is defined in the conformance checker. So, to help you further I need to know how its defined.
Please click on the View process model tab in the conformance checker and send me a screenshot of the process model.
I want a picture like this:

view process model.PNG1927432 40.7 KB

Best wishes,
Calandra

---

Hi Calandra,
Here is the BPM snapshot. We might change it in future but this is our starting point

image001.png771839 23.8 KB

---

Ok, so to test whether a case follows a certain process path MATCH_PROCESS_REGEX("activity table.activity column, ) is used, it returns a 1 if the cases follows that path 0 other wise. A case when statement then needs to assign all conforming processes the value 1 and 0 if it doesnt. These gives a 1 or 0 for each case. To find the proportion the average of these 0 and 1 is formed, giving a decimal. It can be converted to a percentage by changing the formatting to Percentage with decimal.
Heres the PQL code for your current process model:

AVG(CASE WHEN MATCH_PROCESS_REGEX(activity table.activity column,
^Create Service Order Item >> Order: Ready For Scheduling >> Oder: Scheduled >> Create Confirmation Item >> Order: Ready to Bill >> Create DMR Item >> Order: Invoiced $) = 1 THEN 1
ELSE 0
END)

To briefly explain the syntax, ^A means the process must start with activity A, A >> B means A must be directly followed by activity B and "Z $ means the process must end with activity Z. MATCH_PROCESS_REGEX() is very powerful and flexible so if you find you want to modify the process path to be more complicated please ready the help pages to the function.
Does this achieve your desired result?
Best wishes,
Calandra

---

Hi Calandra,
Thanks for the code. I added the Activity table and tried to check the result but getting below error:

Here is the PQL
AVG(CASE WHEN MATCH_PROCESS_REGEX("_CEL_CRM_ACTIVITIES_I_I".ACTIVITY_EN,
^Create Service Order Item >> Order: Ready For Scheduling >> Oder: Scheduled >> Create Confirmation Item >>
Order: Ready to Bill >> Create DMR Item >> Order: Invoiced $) = 1 THEN 1
ELSE 0
END)
Anything which I am doing wrong? Thanks !

---

Hi,
they error is due to you using single and double quotation marks copied out of the community. Annoyingly in the Community formats them in such a way that the Celonis doesnt consider them to be quotes and treats them as unknown symbols. If you just go through the code and delete the quotes replacing them with ones youve typed the problem will go away.
to demonstrate, this is the code copied straight into Celonis:

Copied from the community.PNG1087197 15.7 KB

And this is the same code with the commas corrected:

Quotes corrected.PNG1071132 11.5 KB

Note that the text in single commas is white, its an easy way to spot the problem.
Im sorry I should have mentioned in my last post that replacing the commas would be necessary.
Best wishes,
Calandra

---

Thanks Calandra,
It worked and helped a lot. Thanks for the support !

---