Newer Version Available

This content describes an older version of this product. View Latest

Try It Out: Create Additional Reports

We'll be creating a small-scale recruiting dashboard in this chapter, but before we do, let's use our new report-building skills to create a few more reports. Because we're already familiar with how report builder works, we'll just outline the specifics of a few reports in the following table—you can either create them on your own, or just familiarize yourself with the options.

Want to click along with our dashboard instructions but don't want to spend your time creating all these new reports? Just create the Positions Open Longer Than 90 Days report in the first row. However, if you're interested in recreating the sample dashboard displayed here, you'll need to create the other four as well.

Tip

Table 1. Additional Recruiting Report Specifications
Report Name Question Report Type Options
Positions Open Longer Than 90 Days Which positions have been open for more than 90 days? Positions Format: Summary Report

Summarize information by: Location and then by Functional Area

Columns: Position: Position Title, Position: Owner Name, Status, Open Date, Hire By, Days Open

Filters: All Positions; Days Open greater or equal 90

Chart Type: Pie

Chart Wedges: Functional Area

Chart Title: Positions Open Longer Than 90 Days

Job Applications by Functional Area Which positions are getting the most candidates? Job Applications with Position Format: Summary Report

Summarize information by: Position: Functional Area and then by Position: Position Title

Columns: Job Application Number, Job Application Status

Filters: All job applications; Position: Status equals Open - Approved

Chart Type: Vertical Column

X-Axis: Position: Functional Area

Chart Title: Job Applications by Functional Area

Employee Interviewers Which employees conduct the most interviews? Job Applications with Reviews Format: Summary Report

Summarize information by: Review: Created By

Columns: Job Application: Job Application Number, Job Application: Position, Job Application: Status, Review: Created Date

Filters: All job applications

Chart Type: Pie

Chart Title: Employee Interviewers

Recruiter Status What does the job application pipeline look like for each recruiter and open position? Job Applications with Position Format: Matrix Report

Subtotal Rows by: Position: Owner Name and then by Position: Position Title

Subtotal Columns by: Job Application Status

Columns: Job Application: Job Application Number

Filters: All job applications; Job Application: Last Modified Date Last 120 Days; Position: Status equals Open - Approved, Closed - Filled

Positions Hired in Last 90 Days Who have we hired in the last 90 days? Positions Format: Summary Report

Summarize information by: Functional Area

Columns: Position: Position Title, Position: Owner Name, Hiring Manager, Job Level, Location, Close Date

Filters: All positions; Close Date Last 90 Days; Status equals Closed - Filled