How do I add Total Submissions field to Hired Candidates by Requistion report?
SummaryI have a request to add Total submissions for each requisition that has a hired candidate listed.
The OBI Analysis currently has a row for each candidate hired for a requisition (usually 1). I would like to add the total number of submissions to the report. All counts such as # Submissions will be 1 because the Candidate Hired Name is include. With the candidate data included I can't find a way to get the Total # Submissions for the Requisition. The report currently incudes the following fields:
"Recruiting"."Candidate Identification"."Name" s_1,
"Recruiting"."Profile Source"."Profile Source (BL)" s_2,
"Recruiting"."Requisition Admin Other"."Additional Information" s_3,