# Requisitions by Recruiter |
"Requisition Counts"."# Requisitions By Recruiter" |
# Applicants / Recruiter |
FILTER("Candidate Counts"."# Submissions By Recruiter"
USING (("Submission General Info"."Submission Is Completed"='Yes')
AND ("Submission Prescreening Results"."Minimum Requirements Met"='Yes'))) |
# Reviewed / Recruiter |
FILTER("Candidate Counts"."# Submissions By Recruiter"
USING ("Submission Dates"."Reviewed Date" IS NOT NULL)) |
# Interviewed / Recruiter |
FILTER("Candidate Counts"."# Submissions By Recruiter"
USING ((("Submission Dates"."1st Interviewed Date" IS NOT NULL)
OR ("Submission Dates"."2nd Interviewed Date" IS NOT NULL))
OR ("Submission Dates"."3rd Interviewed Date" IS NOT NULL))) |
# Hired / Recruiter |
FILTER("Candidate Counts"."# Submissions By Recruiter"
USING ("Submission Dates"."Hired Date" IS NOT NULL)) |
# Recruiters |
COUNT(DISTINCT "Requisition Recruiter"."Recruiter ID") |