How to calculate time from different events

Summary

Calculate time difference between different phases (events) in a recruitment process

Content

Hi,

I´m trying to create a report where I can report on the different stages in a recruitment process. I´m using the subject area Recruiting Events Real Time and using formulas similar to the one below to catch the exact dates:

(TIMESTAMPDIFF(SQL_TSI_DAY, MIN(CASE WHEN "Job Requisition History - Event Details"."Phase Code" = 'REQUISITION_DRAFT' THEN  "Job Requisition History - Event Details"."Event Date"  ELSE NUll END),MAX(CASE WHEN "Job Requisition History - Event Details"."Phase Code" = 'REQUISITION_POSTING' THEN  "Job Requisition History - Event Details"."Event Date"  ELSE NUll END)))