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

Count Distinct Requisitions

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

Summary

Taking counts of reqs based on candidates step/status

Content

I am trying to break down open requisition counts based on whether or not they have candidates in Review, Interview, Offer or Checks.  Currently, I am filtering # of Reqs based on submission step/status however if a req has candidates in more than one step, it is being double counted.  Is there a way to do a DISTINCT COUNT of reqs based on Submission Steps?!  Here is an example of where I am trying to go:

COUNT(DISTINCT FILTER("Requisition Counts"."# Requisitions"  USING (("Submission CSW Status - Current"."Current Step Name" NOT IN ('Checks', 'Hire', 'Interview', 'Offer')) AND ("Submission CSW Status - Current"."Current Status Name" NOT IN ('Candidate Has Withdrawn', 'Reject', 'Rejected'))))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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