Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Count Distinct Requisitions
Summary
Taking counts of reqs based on candidates step/statusContent
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'))))
Tagged:
1