Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Counting Candidates in "Pipeline" — Cloud Customer Connect
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

Counting Candidates in "Pipeline"

Accepted answer
59
Views
2
Comments
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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