Time (days) Spent in Step
Summary
Time (days) Spent in StepContent
Looking for some help. I would like to show number days spent in each step, particularly from our Post-Offer Screening step to the Hire step. And then how can I also get an average of this for all candidates hired YTD?
I tried the below formula, but it is not returning any values. The case formulas will return a date when used on its own, but it is not working when I use the TIMESTAMPDIFF. Any help would be appreciated.
TIMESTAMPDIFF(SQL_TSI_DAY, (CASE WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Post-Offer Screening' AND "Submission CSW Status - Historical"."Historical Status Name" = 'To be Screened' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END), (CASE WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Hire' AND "Submission CSW Status - Historical"."Historical Status Name" = 'Hire' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END))