Hello,

Could you kindly post the PQL code thats responsible for calculating throughput time?

The easiest solution can be using ACTIVITY_LAG/ACTIVITY_LEAD with DAYS_BETWEEN functions:

DAYS_BETWEEN ( "ACTIVITIES"."EVENTTIME", ACTIVITY_LEAD ( "ACTIVITIES"."EVENTTIME" ) )

Documentation: <your-celonis-link>/help/display/CIBC/ACTIVITY_LAG

If you're looking for more complicated tasks like calculating cycle time between specific process activities, you will need to use different functions like PU_FIRS/PU_LAST, LAG/LEAD, DAYS_BETWEEN. More info here.

Best Regards,

Mateusz Dudek

Hi,

Thanks for your response.

1. PQL Code for throughput time in days: AVG(CALC_THROUGHPUT(ALL_OCCURRENCEC'Process Start'] TO ALL_OCCURRENCEC'Process End'], REMAP_TIMESTAMPS("DATA_(3)_Sheet1"."COMPLETION_DATE", DAYS))) which is for the screenshot I showed above. Is this what you are looking for?
2. In terms of using activity_lag with days_between: what should I be replacing "activities" and "eventtime" with?

Thanks,

Terence

Hello,

1. Right, current formula calculates average time of whole process for whole cases (Process Start > Process End).
2. You should replace those with the name of column containing time of a event in your eventlog. Other solution (better one) would be to change a names to more standard ones. If "DATA_(3)_Sheet1 contains events from your system the ready formula will look like this: DAYS_BETWEEN ( "DATA_(3)_Sheet1"."COMPLETION_DATE", ACTIVITY_LEAD ("DATA_(3)_Sheet1"."COMPLETION_DATE" ))

Best Regards,

Mateusz Dudek

I actually just figured it out, and your previous comment helped a lot! Thank you very much :)

I was able to get what I needed. Really appreciate it!

Thanks,

Terence