Recruiting - Source Yield Stats (Line Trellis)

The trellis provides a table view of trends for sources across a variety of measures.

Source Volume and Conversion Rate Trends

Selected Columns

This table shows graph data and syntax if any

Name	Syntax
Filled Period	EVALUATE('to_char(%1,%2)' as char,"Requisition Dates"."Latest Filled Date",'YYYY-MM')
Source Type	"Submission Source"."Submission Source Type (Display As)"
Source	"Submission Source"."Submission Source (BL)"
# Submissions Complete	"Candidate Counts"."# Submissions Complete"
# Submissions Met Reqs.	"Candidate Counts"."# Submissions Min. Requirements Met"
# Submissions Ace	"Candidate Counts"."# Submissions Ace"
# Submissions Reached 1st Intv.	"Candidate Counts"."# Submissions Reached 1st Intv."
# Submissions Hired	"Candidate Counts"."# Submissions Currently Hired"
# Ace Hires	FILTER("Candidate Counts"."# Submissions Currently Hired" USING ("Submission Prescreening Results"."Is Ace" = 'Yes'))
% Submissions Complete	cast("Candidate Counts"."# Submissions Complete"/"Candidate Counts"."# Submissions" as float) * 100
% Submissions Met Reqs.	cast(FILTER("Candidate Counts"."# Submissions Min. Requirements Met" USING ("Submission General Info"."Submission Is Completed"='Yes'))/ "Candidate Counts"."# Submissions Complete" as float)*100
% Submissions Ace	cast(FILTER("Candidate Counts"."# Submissions Ace" USING ("Submission General Info"."Submission Is Completed" = 'Yes'))/ "Candidate Counts"."# Submissions Complete" as float)*100
% Submissions Reached 1st Intv	cast("Candidate Counts"."# Submissions Reached 1st Intv."/"Candidate Counts"."# Submissions Complete" as float) * 100
% Submissions Hired	cast("Candidate Counts"."# Submissions Currently Hired"/"Candidate Counts"."# Submissions Complete" as float) * 100
% Ace Hires	cast( FILTER("Candidate Counts"."# Submissions Currently Hired" USING ("Submission Prescreening Results"."Is Ace"='Yes')) /"Candidate Counts"."# Submissions Ace" as float) * 100

Filters

This table shows report filters

Name
Submission Source Type (Display As) is not null
Submission Source Type (Display As) is prompted
Submission Source (BL) is prompted
Recruiting - Summary Dashboard Prompt Listener

Trellis Configuration

This table shows graph configuration

Name	Location
Rows	Source
Measures	# Submissions Complete % Submissions Complete # Submissions Met Min Reqs. % Submissions Met Min Reqs. # Submissions Ace % Submissions Ace # Submissions Reached 1st Intv. % Submissions Reached 1st Intv. # Submissions Hired % Submissions Hired # Ace Hires % Ace Hires
Visualization View As: Spark Line Lines: Filled Period	# Submissions Complete # Submissions Met Min Reqs. # Submissions Ace # Submissions Reached 1st Intv. # Submissions Hired # Ace Hires
Visualization View As: Spark Bar Bars: Filled Period	% Submissions Complete % Submissions Met Min Reqs. % Submissions Ace % Submissions Reached 1st Intv. % Submissions Hired % Ace Hires