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
| 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
| 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
| 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
| Name | Location |
|---|---|
| Columns | Latest Filled Date |
| Rows | Stage |
| View as | Pie |
| Slices | Submission Source (BL) # Submissions |