Reference: Visualizations by Topic Area
Use the configuration details in the tables to recreate People Analytics visualizations across topic areas. You can then add additional fields and specifications to customize your analysis according to the needs of your business.
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'
'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'
'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'
'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'
'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: Value Total - Descending Override Y-Axis Display Name: Active Headcount Color: Gender | 'Active Status' = 'is true'
'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'
'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'
'Snapshot_Index' = 'is between', value: [1, 13] |
Top 5 Termination Reasons by Gender - Rolling 3 Months | Rolling 3 months. 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'
'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'
'Snapshot_Index' = 'is between', value: [1, 1] | |
Average Compa-Ratio by Top 10 Locations | 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'
'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: 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'
'Promoted this Period' = 'is true' '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'
'Snapshot_Index' = 'is between', value: [1, 1] | |
Average Tenure by Top 10 Locations | 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'
'Snapshot_Index' = 'is between', value: [1, 1] | |
Headcount Movement - Rolling 3 Months | Rolling 3 months | 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]
| 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'
'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 Override Y-Axis Display Name: Active Headcount | 'Active Status' = 'is true'
'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'
'Snapshot_Index' = 'is between', value: [1, 12] | |
Monthly Average Number of Directs by Organization Level | Rolling 12 months | Type: Heatmap | X-Axis: Month
Y-Axis: Organization Level Y-Axis Sort Order: Alphabetical - Descending Color: AVG(Direct Reports) Override Color Display Name: Average Number of Directs | 'Active Status' = 'is true'
'Manager With Direct Reports' = 'is true' '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
Override Y-Axis Display Name: Active Headcount | 'Active Status' = 'is true'
'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'
'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 - Rolling 3 Months | Rolling 3 months | 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'
'Snapshot_Index' = 'is between', value: [1, 3] 'Terminated This Period' = 'is true' | New Hires are defined as workers with less than 1 year of tenure. |
Termination Count by Job Family Group - Rolling 3 Months | Rolling 3 months | 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 | 'Snapshot_Index' = 'is between', value: [1, 3]
'Terminated This Period' = 'is true' | |
Termination Count by Management Level - Rolling 3 Months | Rolling 3 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Management Level
X-Axis Sort Order: Value Total - Descending Override Y-Axis Display Name: Terminated Headcount | 'Snapshot_Index' = 'is between', value: [1, 3]
'Terminated This Period' = 'is true' | |
Termination Count by Tenure Category - Rolling 3 Months | Rolling 3 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Tenure Category
Override Y-Axis Display Name: Terminated Headcount | 'Snapshot_Index' = 'is between', value: [1, 3]
'Terminated This Period' = 'is true' | The tenure categories are defined at the tenant level. |
Terminations by Compa-Ratio Range - Rolling 3 Months | Rolling 3 months | 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 | 'Snapshot_Index' = 'is between', value: [1, 3]
'Terminated This Period' = 'is true' | The Compa-ratio ranges are defined at the tenant level. |
Top 10 Locations for New Hire Terminations - Rolling 3 Months | Rolling 3 months | 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'
'Snapshot_Index' = 'is between', value: [1, 3] 'Terminated This Period' = 'is true' | New Hires are defined as workers with less than 1 year of tenure. |
Top 10 Voluntary Termination Reasons by Gender - Rolling 3 Months | Rolling 3 months | 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 | 'Snapshot_Index' = 'is between', value: [1, 3]
'Termination Category' = 'is in list', value: [Voluntary] '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]
'Termination Category' = 'is in list', value: [Voluntary] 'Terminated This Period' = 'is true' |
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: Req_Management_Level_Job_Requisition
X-Axis Sort Order: Value Total - Descending Override X-Axis Display Name: Management Level Requisition Y-Axis: AVG(Time To Fill) Override Y-Axis Display Name: Average Time to Fill in Days | 'Req_Management_Level_Job_Requisition' = 'is not
empty'
'Last Requisition Entry' = 'is in list', value:
[1] 'Last_Year' = 'is in list', value: [1] 'Requisition_Time_To_Fill' = 'not
equals', value: [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 | 'Last_Year' = 'is in list', value: [1]
'Hired this Period' = 'is in list', value: [yes] | 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 | 'Last_Year' = 'is in list', value: [1]
'Hired this Period' = 'is in list', value: [yes] | |
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 | 'Candidate Job Requisition Status Instance Evaluated' = 'is in list', value: [open]
'Req_Management_Level_Job_Requisition' = 'is not empty' 'Last Requisition Entry' = 'is in list', value: [1] 'Job Requisition Age Category' = 'is not blank' | 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 | 'Last_Year' = 'is in list', value: [1]
'Req_Opened_This_Month' = 'is in list', value: [1] | The data source only includes requisitions that have at least 1
candidate attached to the requisition. |
Top 10 Decline Reasons - Rolling 12 Months | Rolling 12 months | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Disposition Reason
X-Axis Sort Order: Value Total - Descending X-Axis Limit: 10 groupings Override X-Axis Display Name: Decline Reason Override Y-Axis Display Name: Number of Candidates | 'Candidate Stage Instance Evaluated' = 'is in list', value: [declined by
candidate, rejected]
'Stage Consolidated' = 'is in
list', value: [offer] 'Last_Year' = 'is in list', value: [1] | 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 | 'Active Status' = 'is true'
'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
Y-Axis: Current Rating | 'Active Status' = 'is true'
'Snapshot_Index' = 'is between', value: [1, 1] | |
Current Rating Overview | Current snapshot period | Type: Bar Chart
Orientation: Vertical Grouping: Cluster | X-Axis: Current Rating
Override Y-Axis Display Name: Active Headcount | 'Active Status' = 'is true'
'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
Override Y-Axis Display Name: Terminated Headcount Color: Termination Category | 'Terminated This Period' = 'is true'
'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'
'Snapshot_Index' = 'is between', value: [1, 12] 'Terminated This Period' = 'is true' | High potentials are defined at the tenant level. |
Top 5 Voluntary Termination Reasons 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'
'Snapshot_Index' = 'is between', value: [1, 12] 'Terminated This Period' = 'is true' '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'
'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 Override Y-Axis Display Name: Active
Headcount | 'Active Status' = 'is true'
'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'
'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 | 'Active Status' = 'is true'
'Snapshot_Index' = 'is between', value: [1, 1] |