Hi There,
I would like to get Average throughput time between activity A and whatever activity coming after A.
For example;
Case 1 / Activity Sequence: A->B->C->D->A->Z
I need the sum of throughput times case level (A->B) + (A->Z)
I also need number of occurrences of A case level (2)
..
Finally my resulting KPI formula will be like;
Total throughput time (A and next activity) / Total Number of Occurrences of A
How can we make it happen in PQL?
Thanks in advance,
Best Regards,
Oguzhan
Hello Oguzhan,
You should be able to accomplish this by using a CASE WHEN and when it matches your desire activity A you can calculate time to the next activity with SOURCE_TARGET (https://help.celonis.cloud/help/display/CIBC/SOURCE+-+TARGET).
For the occurrence count you can as well do a Case WHEN that returns 1 when A and 0 when Else and sum the total.
And for the total KPI you could just divide one by the other.
Hope this helps you solve the issue.
For any further questions do not hesitate to ask.
Best regards,
Pablo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
