Skip to main content
Question

Time between same activity for different cases

  • February 27, 2025
  • 2 replies
  • 40 views
roman.stolz
Level 1
Forum|alt.badge.img

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!

    2 replies

    abhishek.chatu14
    Level 11
    Forum|alt.badge.img+4

    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"))

    abhishek.chatu14
    Level 11
    Forum|alt.badge.img+4

    Of course you would need to filter the activity 

    Community Code of ConductAccessibility statement