We are not able to edit any out of box analysis like Conformance checker, Social Analysis etc. We would like to use some of the components / formulas from these analysis into our single analysis for the users. How can we achieve the same?
I’m 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.
Thanks Calandra for support here.
Example of the KPI’s 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:
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 doesn’t. 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’.
Here’s 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
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?
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
Anything which I am doing wrong? Thanks !
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 doesn’t 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 you’ve typed the problem will go away.
to demonstrate, this is the code copied straight into Celonis:
And this is the same code with the commas corrected:
Note that the text in single commas is white, it’s an easy way to spot the problem.
I’m sorry I should have mentioned in my last post that replacing the commas would be necessary.
It worked and helped a lot. Thanks for the support !