Comparing timestamps of 2 cases

If you’re comparing two specific cases use the following PQL 
 

VAR_A = 
  ACTIVITY_TIMESTAMP(
    FILTER "ACTIVITY" = 'Activity X' AND "CASE_ID" = '1001'
  )

VAR_B = 
  ACTIVITY_TIMESTAMP(
    FILTER "ACTIVITY" = 'Activity Y' AND "CASE_ID" = '1002'
  )

DURATION_BETWEEN(VAR_A, VAR_B, "MINUTES")


But if you want to compare across all cases dynamically:

1- Duplicate the activity table in the data model (self-join on activity name or any logic)

2- Assign aliases like A.ACTIVITY_TIME, B.ACTIVITY_TIME

3- Join based on your matching condition (e.g., compare timestamps of same activity across related cases)

Then apply: DURATION_BETWEEN("A"."EVENTTIME", "B"."EVENTTIME", "HOURS")

Good morning Rami, thank you very much for your assistance, I will try it out. Regards,

Denise