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 Name, 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

Lightning Platform Fundamentals

Try It Out: Create Additional Reports