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

Most advanced candidate report

Received Response
73
Views
9
Comments
edited Apr 10, 2017 8:04PM in Reporting and Analytics Taleo Enterprise 9 comments

Summary

We have designed a report to provide the details of the most advanced candidate. The report pulls the candidate's step and status and also the candidate's name, need date

Content

Report currently pulls the most advanced candidate for all open requisitions. The report pulls the step and status of the candidate and the name of the candidate. However, we would like to pull the date the candidate entered that status but we are having some difficulties. For the candidate name we used this formula, but it doesn't work for the date:

 

MAX(CASE WHEN Rank(CAST(Replace(concat(CAST("Submission CSW Status - Historical"."Historical Step Sequence" AS CHAR(5)),CAST("Submission CSW Status - Historical"."Historical Status Sequence" AS CHAR(5))),' ','') AS Integer) BY "Requisition Identification"."Req. Identifier")=1 THEN "Candidate Identification"."Name" ELSE '' END BY "Requisition Identification"."Req. Identifier")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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