Time between same activity for different cases | Community

Hey,
I have an activity that every case has to go through. I would like to know how long the time is between each case. (This is interesting for me because only 1 case can go through the activity at a time and we want to analyze the “empty” time).
Does anyone have an idea how to calculate this?

Thanks for helping!

Page 1 / 1

I would suggest creating an OLAP table with the Case Key and the throughput time

If you have an End Timestamp, you can calculate the duration using:
DATEDIFF(dd, "Table1"."StartTime", "Table1"."EndTime")
If you don’t have an End Timestamp, use LEAD to fetch the next event timestamp and calculate the gap:
DATEDIFF(dd, "Table1"."EventTime", LEAD("Table1"."EventTime"))

Of course you would need to filter the activity

Reply