Skip to main content

Hi

I am trying to calculate the time elapsed since the occurrence of a particular activity and all subsequent activities in the case.

For example, if there are 5 activities in a case, of which the activity 'Lodgement' is the second activity.

I would like to calculate the time take between 'Lodgement' and the 3rd activity, 'Lodgement' and the 4th activity and 'Lodgement' and the 5th activity.

Note:

1.The number of activities per case is not a fixed number.

2.The occurrence of 'Lodgement' activity is not fixed in the activity order.

 

Any pointers on how this can be done in PQL is much appreciated.

Many Thanks

Ashwin Hosbett

A bit rusty here (almost 1 year not touching Celonis) but, IIRC, you can use activity_lead and activity_lag to get the datetime of the following activities.

If you are doing that in Python, you can put that inside a "for" or while loop to increase the offset parameter to get the time from ona activity to all the others

 

HTH

 

Reply


Terms & ConditionsCookie settings