Recruiting - Source Yield Top Sources Trend (Pie Trellis)

The trellis provides a table view of pie charts displaying top 5 sources by stage conversion, enabling an at a glance view of top 5 source performance over time.

Top 5 Source Trends By Stage

Selected Columns

This table shows graph data and syntax if any

Name	Syntax
Stage (Data Identifier)	Each of the 6 unioned criteria has a unique data identifier.
Source Type	"Submission Source"."Submission Source Type (Display As)"
Submission Source	"Submission Source"."Submission Source (BL)"
# Submissions	The value used for # of submissions varies based on stage.
Filled Period	EVALUATE('to_char(%1,%2)' as char, "Requisition Dates"."Latest Filled Date",'YYYY-MM')

Unique Columns/Filters

This table shows report filters

Data Identifier	# Submissions	Additional Filter(s)
'1. All Submissions'	"Candidate Counts"."# Submissions"
'2. Completed Submissions'	"Candidate Counts"."# Submissions"	Submission Is Completed is equal to / is in Yes
'4. Interviewed'	"Candidate Counts"."# Submissions Reached 1st Intv."
'3. Reviewed'	"Candidate Counts"."# Submissions Reached Reviewed"
'5. Hired'	"Candidate Counts"."# Submissions Currently Hired"
'6. Hires Ace'	"Candidate Counts"."# Submissions Currently Hired"	Is Ace is equal to /is in Yes

Filters

This table shows report filters

Name
Submission Source Type (Display As) is not null
Rank("Candidate Counts"."# Submissions Currently Hired" By EVALUATE('to_char(%1,%2)' as char, "Requisition Dates"."Latest Filled Date",'YYYY-MM')) is less than or equal to 5
Submission Source (BL) is prompted
Submission Source (Display As) is prompted
Recruiting - Summary Dashboard Prompt Listener

Trellis Configuration

This table shows graph data and syntax if any

Name	Location
Columns	Latest Filled Date
Rows	Stage
View as	Pie
Slices	Submission Source (BL) # Submissions