You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Time (days) Spent in Step

edited Dec 13, 2022 7:09AM in Taleo Enterprise 2 comments

Summary

Time (days) Spent in Step

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!