We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Timediff from one status to another

Received Response
30
Views
2
Comments
edited Jul 2, 2019 10:39AM in Reporting and Analytics Taleo Enterprise 2 comments

Content

Hi,

I am trying to get the time taken from one status to another.

Ex: Need to know what is the time taken from to be reviewed to Initiate ability test

  From To
Step Name Under Review  Assessment
Status Name To Be Reviewed Initiate Ability Test

Tried below and couldn't succeed. Kindly help.

MIN(TIMESTAMPDIFF(SQL_TSI_DAY,(CASE "Submission CSW Status - Historical"."Historical Status Name" WHEN 'To Be Reviewed' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END),(CASE "Submission CSW Status - Historical"."Historical Status Name" WHEN 'Initiate Ability Test' 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!