Skip to main content

Hi! I have a large activity table and am confused how to calculate the difference between current line timestamp and prior line timestamp. example: line 2 timestamp - line 1 timestamp, then line 3-line 2, etc through all the steps of the case

 

I can do this in the PQL with a lag function but was advised to look into this from a Celonis calculation. Is there a particular function I should be looking at or a way to do this? While the case explorer, this seems to be done automatically, but I cannot figure a way to do this within a dashboard. Thanks!

Hello,
My initial suggestion would be to use a LAG function. Where would this calculation be located, and how would it be used? Perhaps that would help better understand if there is a better way of handling this.

Reply