How do I use PU_FIRST and PU_LAST function to calculate the total wait time between my operations?

Are operations modeled as Activities?

Hi Yes, the operations are incorporated to form the activities. Giving the Above example

_CASE_KEY: 01000200

• OPERATION 0001

1. ACTIVITY 1 [0001] - Create
   1. ACTIVITY 2 [0001] - Modify
   2. ACTIVITY 3 [0001] - Delete

• OPERATION 0100

1. ACTIVITY 1 [0001] - Create
   1. ACTIVITY 2 [0001] - Modify
   2. ACTIVITY 3 [0001] - Delete

The same structure gets repeated for all of the CASES and each case can have N operations.

Ok... here the main problem is to define "next" case... as we expect the cases are not sequential.

But let's imagine you have a way to know which is the next case.

To know the first activity of a case you can use INDEX_ACTIVITY_ORDER and look for the one with 1

https://docs.celonis.com/en/index_activity_order.html

The last one is more tricky.... you can use INDEX_ACTIVITY_ORDER combined with count_table(activity_table) to know how many activities has a case, then search for the activity with INDEX_ACTIVITY_ORDER.

Also you can use PU_MAX(CASE_TABLE, ACTIVITY_TABLE.EVENTTIME) to get the last activity per case.

Also INDEX_ORDER can help

https://docs.celonis.com/en/index_order.html

Maybe combining the above ideas you can get what you want. A lot depends on, for starters, how to identify the "next" case. And if you need this as a single KPI, combined in a OLAP table, etc....

HTH

Hi @Guillermo Gost , I was able to get what I wanted using the Source and Target. Thank you for your help!