Reference: Visualizations by Topic
Use the configuration details in the tables to recreate People Analytics visualizations across topics. You can then add additional fields and specifications to customize your analysis according to the needs of your business.
Because we round all values to the nearest tenth decimal point, percent values in visualizations might not add up to 100% exactly. This is expected.
Diversity and Inclusion
Visualization | Time Frame | Graph Type | Fields | Filters |
|---|---|---|---|---|
Ethnicity Trend | Rolling 12 months | Type: Line Chart | X-Axis: Month Override Y-Axis Display Name: Active Headcount Color: Ethnicity | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] |
Gender by Tenure Category | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Stack to 100 | X-Axis: Tenure Category Override Y-Axis Display Name: Active Headcount Color: Gender | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] |
Gender Trend | Rolling 12 months | Type: Line Chart | X-Axis: Month Override Y-Axis Display Name: Active Headcount Color: Gender | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] |
Generation Trend | Rolling 12 months | Type: Line Chart | X-Axis: Month Override Y-Axis Display Name: Active Headcount Color: Generation | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] |
Management Level by Gender | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Stack to 100 | X-Axis: Management Level X-Axis Sort Order: Management Level Seniority - Ascending Override Y-Axis Display Name: Active Headcount Color: Gender | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] |
Termination Count by Ethnicity | Rolling 12 months | Type: Heatmap | X-Axis: Month Y-Axis: Ethnicity | 'Terminated This Period', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] |
Termination Count by Generation | Rolling 12 months | Type: Heatmap | X-Axis: Month Y-Axis: Generation | 'Terminated This Period', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] |
Top 5 - Termination Reasons by Gender - Previous Quarter | Previous fiscal quarter.
This graph might adjust each snapshot period due to the volume of terminations per category. | Type: Bar Chart
Orientation: Vertical Grouping: Stack | X-Axis: Termination Reason X-Axis Sort Order: Value Total - Descending X-Axis Limit: 5 groupings Sum Remaining Values for X-Axis: False Override Y-Axis Display Name: Terminated Headcount Color: Gender Color Sort Order: Value Total - Descending | 'Terminated This Period', 'is true' AND 'Complete_snapshot_index', 'is between', value: [1, 3] |
Organization Composition
Visualization | Time Frame | Graph Type | Fields | Filters | Notes |
|---|---|---|---|---|---|
Average Compa-Ratio by Job Family Group | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Job Family Group X-Axis Sort Order: Value Total - Descending Y-Axis: AVG(Compa-Ratio) Override Y-Axis Display Name: Average Compa-Ratio | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Average Compa-Ratio by Top 10 - Location | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Location X-Axis Sort Order: Value Total - Descending X-Axis Limit: 10 groupings Sum Remaining Values for X-Axis: False Y-Axis: AVG(Compa-Ratio) Override Y-Axis Display Name: Average Compa-Ratio | 'Active Status', 'is true' AND 'Snapshot_Index' = 'is between', value: [1, 1] | |
Average Tenure at Promotion by Management Level - Rolling 12 Months | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Management Level X-Axis Sort Order: Management Level Seniority - Ascending Y-Axis: AVG(Length of Service In Partial Years) Override Y-Axis Display Name: Average Tenure in Partial Years | 'Active Status', 'is true'
AND 'Promoted this Period', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 12] | |
Average Tenure by Job Family Group | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Job Family Group X-Axis Sort Order: Value Total - Descending Y-Axis: AVG(Length of Service In Partial Years) Override Y-Axis Display Name: Average Tenure in Partial Years | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Average Tenure by Top 10 - Location | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Location X-Axis Sort Order: Value Total - Descending X-Axis Limit: 10 groupings Sum Remaining Values for X-Axis: False Y-Axis: AVG(Length of Service In Partial Years) Override Y-Axis Display Name: Average Tenure in Partial Years | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Quarterly Headcount Movement | Previous fiscal quarter | Type: Waterfall
Orientation: Vertical | Measures:
Viz Options: Show data labels: True Hide total: False Override X-Axis Display Name: " " Override Y-Axis Displaye Name: Worker Count Override Measure Display Names:
| 'Headcount Movement', "is in list', value: [Headcount Movement] AND 'Complete_snapshot_index', 'is between', value: [1, 3] | The headcount movement graph starts with a beginning active headcount and after aggregates hires, terminations, and transfers for the next 3 months. The last bar displays the active headcount with those changes at the end of the 3 month period. Transfers include both true transfers and reorganizations. |
Managers vs Individual Contributors by Job Family Group | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Stack to 100 | X-Axis: Job Family Group X-Axis Sort Order: Value Total - Descending Override Y-Axis Display Name: Active Headcount Color: Manager vs Individual Contributor | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Managers vs Individual Contributors by Tenure Category | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Stack to 100 | X-Axis: Tenure Category Color: Manager vs Individual Contributor X-Axis Sort Order: Tenure Length - Ascending Override Y-Axis Display Name: Active Headcount | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Monthly Active Headcount | Rolling 12 months | Type: Line Chart | X-Axis: Month Override Y-Axis Display Name: Active Headcount | 'Active Status', 'is true'
AND 'Snapshot_Index', 'is between', value: [1, 13] | |
Monthly Average Number of Directs by Organization Level | Rolling 12 months | Type: Heatmap | X-Axis: Report Month X-Axis Sort Order: Alphabetical - Ascending Y-Axis: Organization Level, Color: "Org_Level" Y-Axis Sort Order: Organizational level - Ascending Color: AVG(Direct Reports) Override Color Display Name: Average Number of Directs | 'Active Status', 'is true' AND 'Manager With Direct Reports', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] | |
Organizational Depth in Layers | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Organization Level X-Axis Sort Order: Organization Level - Ascending Override Y-Axis Display Name: Active Headcount | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | Each layer represents an aggregated group of employees based on their level in the organization. This visualization helps you understand the shape of the workforce and gives a visual representation of where your organization might be top or bottom heavy. |
Organization Levels by Management Level | Current snapshot period | Type: Heatmap | X-Axis: Organization Level Y-Axis: Management Level | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | This visualization might reveal whether employees at higher management levels are far from the top levels of the organization. |
Retention and Attrition
Visualization | Time Frame | Graph Type | Fields | Filters | Notes |
|---|---|---|---|---|---|
New Hire Terminations by Job Family Group - Previous Quarter | Previous fiscal quarter | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Job Family Group X-Axis Sort Order: Value Total - Descending Override Y-Axis Display Name: Terminated Headcount | 'New Hire', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 3] AND 'Terminated This Period', 'is true' AND 'Complete_Snapshot_Index', 'is between', value: [1, 3] | New Hires are defined as workers with less than 1 year of tenure. |
Quarterly Terminations by Compa-Ratio Range | Previous fiscal quarter | Type: Bar Chart
Orientation: Vertical Grouping: Stack to 100 | X-Axis: Compa-Ratio Range X-Axis Sort Order: Alphabetical - Descending Override Y-Axis Display Name: Terminated Headcount Color: Termination Category Color Sort Order: Alphabetical - Descending | 'Complete_Snapshot_Index', 'is between', value: [1, 3] AND 'Terminated This Period', 'is true' | The Compa-ratio ranges are defined at the tenant level. |
Quarterly Termination Count by Job Family Group | Previous fiscal quarter | Type: Bar Chart
Orientation: Vertical Grouping: Stack | X-Axis: Job Family Group X-Axis Sort Order: Value Total - Descending Override Y-Axis Display Name: Terminated Headcount Color: Termination Category Color Sort Order: Value Total - Descending | 'Complete_Snapshot_Index', 'is between', value: [1, 3] AND 'Terminated This Period', 'is true' | |
Quarterly Termination Count by Management Level | Previous fiscal quarter | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Management Level X-Axis Sort Order: Management seniority level - Ascending Override Y-Axis Display Name: Terminated Headcount | 'Complete_Snapshot_Index', 'is between', value: [1, 3] AND 'Terminated This Period', 'is true' | |
Quarterly Termination Count by Tenure Category | Previous fiscal quarter | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Tenure Category X-Axis Sort Order: Management Seniority Level - Ascending Override Y-Axis Display Name: Terminated Headcount | 'Complete_Snapshot_Index', 'is between', value: [1, 3] AND 'Terminated This Period', 'is true' | The tenure categories are defined at the tenant level. |
Top 10 Locations for New Hire Terminations - Previous Quarter | Previous fiscal quarter | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Location X-Axis Sort Order: Value Total - Descending X-Axis Limit: 10 groupings Override Y-Axis Display Name: Terminated Headcount | 'New Hire', 'is true' AND 'Complete_Snapshot_Index', 'is between', value: [1, 3] AND 'Terminated This Period', 'is true' | New Hires are defined as workers with less than 1 year of tenure. |
Top 10 Voluntary - Termination Reason by Gender - Previous Quarter | Previous fiscal quarter | Type: Bar Chart
Orientation: Horizontal Grouping: Stack | Y-Axis: Termination Reason Y-Axis Sort Order: Value Total - Descending Y-Axis Limit: 10 groupings Sum Remaining Values for Y-Axis: False Color: Gender Override X-Axis Display Name: Terminated Headcount | 'Complete_Snapshot_Index', 'is between', value: [1, 3] AND 'Termination Category', 'is in list', value: [Voluntary] AND 'Terminated This Period', 'is true' | Top 10 termination reasons are subject to change each month. |
Voluntary Termination Count by Month | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Month Override Y-Axis Display Name: Terminated Headcount | 'Snapshot_Index', 'is between', value: [1, 13] AND 'Termination Category', 'is in list', value: ['Voluntary'] AND 'Terminated This Period', 'is true' AND 'fiscal_quarter_index', value: [1] |
Hiring
Visualization | Time Frame | Graph Type | Fields | Filters | Notes |
|---|---|---|---|---|---|
Average Time to Fill by Management Level - Rolling 12 Months | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Job Requisition Management Level X-Axis Sort Order: Logical sort - Descending Override X-Axis Display Name: Management Level Requisition X-Axis Sort Order: Management Level Seniority - Ascending Y-Axis: Requisition_Average_Time_To_Fill Override Y-Axis Display Name: Average Time to Fill in Days | 'Req_Management_Level_Job_Requisition', 'is not empty' AND 'Last Requisition Entry', 'is in list', value: [1] AND 'Snapshot_Index', 'between', value: [1, 12] AND 'Requisition_Average_Time_To_Fill', 'not equals', ["0"] | |
Hires per Month | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Month Override Y-Axis Display Name: Number of Hires | 'Snapshot_Index', 'between', value: [1, 12] AND 'Stage_Consolidated', 'in list', ["Hire"] | A hire is recognized by the start date of the new hire. |
Job Application Sources - Rolling 12 Months | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Job Application Source X-Axis Sort Order: Value Total - Descending X-Axis Limit: 20 groupings Override X-Axis Display Name: Source Override Y-Axis Display Name: Number of Hires | : 'Snapshot_Index', 'between', value: [1, 12] AND 'Stage_Consolidated', 'in list', ["Hire"] | |
Number of Open Requisitions by Aging | Current snapshot period | Type: Heatmap | X-Axis: Job Requisition Age Category Y-Axis: Req_Management_Level_Job_Requisition Override Y-Axis Display Name: Management Level | 'Req_Job_Requisition_Status_Instance_Evaluate', 'is in list', ["Open"] AND 'Req_Management_Level_Job_Requisition', 'is not empty' AND 'Last_Requisition_Entry', 'is true' AND 'Req_Age_Category', is not empty | The data source only includes requisitions that have at least 1 candidate attached to the requisition. This visualization helps you:
|
Requisitions Opened each Month | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Month Override Y-Axis Display Name: Number of Requisitions | 'Snapshot_Index', 'between', value: [1, 12] AND 'Req_Opened_This_Month', 'is true' | The data source only includes requisitions that have at least 1 candidate attached to the requisition. |
Top 10 - Decline Reason - Rolling 12 Months | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Decline Reason X-Axis Sort Order: Value Total - Descending Number of X-Axis groupings: 10 Override X-Axis Display Name: Decline Reason Override Y-Axis Display Name: Number of Candidates | 'Latest_Candidate_Stage', 'is in list', ["Declined by candidate", "Rejected"] AND 'Stage_Consolidated', 'is in list', ["Offer"] AND 'Snapshot_Index', 'between', value: [1, 12] | Top 10 decline reasons are subject to change each snapshot period. |
Talent and Performance
Visualization | Time Frame | Graph Type | Fields | Filters | Notes |
|---|---|---|---|---|---|
Current Rating by Job Family Group | Current snapshot period | Type: Heatmap | X-Axis: Job Family Group Y-Axis: Current Rating Y-Axis Sort Order: Worker Rating - Ascending | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | Performance rating is defined at the tenant level. |
Current Rating by Management Level | Current snapshot period | Type: Heatmap | X-Axis: Management Level X-Axis Sort Order: Management Level Seniority - Ascending Y-Axis: Current Rating Y-Axis Sort Order: Worker rating - Ascending | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Current Rating Overview | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Current Rating X-Axis Sort Order: Worker rating - Ascending Override Y-Axis Display Name: Active Headcount | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | Performance rating is defined at the tenant level. |
Termination Count by Current Rating | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Stack | X-Axis: Current Rating X-Axis Sort Order: Worker Rating - Ascending Override Y-Axis Display Name: Terminated Headcount Color: Termination Category | 'Terminated This Period', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] | |
Termination Type of High Potentials by Month | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Stack | X-Axis: Month Color: Termination Category Override Y-Axis Display Name: Terminated Headcount | 'High Potential', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 13] AND 'Terminated This Period', 'is true' | High potentials are defined at the tenant level. |
Top 5 Voluntary - Termination Reason for High Performers - Rolling 12 Months | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Termination Reason X-Axis Sort Order: Value Total - Descending X-Axis Limit: 5 groupings Sum Remaining Values for X-Axis: False Override Y-Axis Display Name: Terminated Headcount | 'High Performer', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 12] AND 'Terminated This Period', 'is true' AND 'Termination Category', 'is in list', value: [Voluntary] | The top 5 reasons might change every snapshot period. |
Skills
Visualization | Time Frame | Graph Type | Fields | Filters |
|---|---|---|---|---|
Match Score Signal by Top 10 Job Family Groups | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Stack to 100 | X-Axis: Job Family Group X-Axis Sort Order: Alphabetical - Ascending Override Y-Axis Display Name: Match Score Signal Percentage Color: Worker Match Score Signal | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] |
Match Score Signal Distribution | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Worker Match Score Signal X-Axis Sort Order: Worker Rating - Ascending Override Y-Axis Display Name: Active Headcount | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] |
Top 10 Skill Categories by Job Family Group | Current snapshot period | Type: Heatmap | X-Axis: Skill Categories X-Axis Sort Order: Value Total - Descending X-Axis Limit: 10 groupings Color: Job Family Group | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] |
Top 10 Skill Categories by Management Level | Current snapshot period | Type: Heatmap | X-Axis: Skill Categories X-Axis Sort Order: Value Total - Descending X-Axis Limit: 10 groupings Y-Axis: Management Level Y-Axis Sort Order: Management Level Seniority - Ascending | 'Active Status', 'is true' AND 'Snapshot_Index', 'is between', value: [1, 1] |