Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Counting Candidates in "Pipeline"

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

Summary

We would like to count the number of unique candidates in specific steps and statuses.

Content

Hi! I'm trying to build a report that shows the number of "active" (what we consider active) candidates by requisition, recruiter, department etc. What we determine to be active is not in application review, offer, or hire, and not rejected or withdrew. So basically any other step/status combo. This is the formula I've tried so far but it's not calculating correctly:

CASE  WHEN "Submission CSW Status - Current"."Current Step Name"||' '||"Submission CSW Status - Current"."Current Status Name" IN ('Application Review HR To Review (Internal Candidates)', 'Application Review Passed', 'Background Check Passed', 'Background Check To Be Checked', 'Background Check Waiting for Results', 'Evaluation To Be Reviewed', 'HM Interview Passed', 'HM Interview To Be Reviewed', 'HM Interview Under Consideration', 'Interviews 1st Interview', 'Interviews 2nd Interview', 'Interviews Additional Interviews', 'Interviews Contacted Again', 'Interviews Passed', 'Interviews Scheduled', 'Interviews To Be Scheduled', 'Interviews Under Consideration', 'Phone screen Passed', 'Phone screen To Be Phone Screened', 'Phone screen Under Consideration', 'Pre-Offer Checks To Be Checked', 'Pre-Offer Checks Waiting

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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