Creating a report of counts
Content
I am trying to quantify the workload of each of my recruiters. So, I am trying to create a report that shows each Req Owner (which is my recruiters) and then give a count of the Requisitions by req Status (example 1 below). Then, I am trying to quanitfy the number of candidates that each is handling by counting candidates by Req-Specific Status (example 2 below). I am using all the functions I see available in the report writer and am finding this nearly impossible. Any ideas?
Example 1:
Recruiter | Open | On Hold | Filled | Closed |
---|---|---|---|---|
Recruiter 1 | 3 | 10 | 5 | 8 |
Recruiter 2 | 7 | 10 | 8 | 5 |
Recruiter 3 | 7 | 15 | 9 | 2 |
Example 2:
Recruiter | Rejected | Hired |
---|
0