Skip to main content
Question

Average throughput time calculation between a certain activity and the next activity comes after it

  • March 14, 2022
  • 1 reply
  • 57 views
O
Level 0

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

 

 

 

 

    1 reply

    P
    Celonaut
    • pablo.maced
    • Celonaut
    • March 30, 2022

    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

     

     

    Community Code of ConductAccessibility statement