How to calculate time from different events
Summary
Calculate time difference between different phases (events) in a recruitment processContent
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)))