Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-09-08
Reference: Workforce Composition Dashboards

Reference: Workforce Composition Dashboards

Secured to the
Trended Worker Data
 domain in the Staffing functional area, workforce composition dashboards help with understanding historical trends for workforce metrics. Composition dashboards help leaders, HR business partners, and managers understand historical trends.
You can configure 5 dashboards that contain a total of 30 worklets built on the
Trended Workers
 data source. The
Trended Workers
 data source is a prerequisite in order to turn on these dashboards in your tenant.
Required prompt settings for all dashboards:
  • Organization - Multi-Instance
  • Include Subordinate Organizations
  • Start Date
  • End Date - This value must be the last day of a historical month to populate values of the dashboards.
You can configure these 5 dashboards using the
Maintain Dashboards
 task:
  • Distribution Trends and Analysis Dashboard
    Security:
    Management Dashboard: Distribution Trends and Analysis
     domain in the System functional area.
    Worklet Name
    Domains
    Calculations
    Global Footprint
    Worker Data: Current Staffing Information
    • Ending Headcount
    Growth Rate by Job Family Group
    Worker Data: Current Staffing Information
    • Ending Headcount
    Headcount and Average YOS by Age Range
    Person Data: Date of Birth
    Worker Data: Current Staffing Information
    • Ending Headcount
    • Average Length of Service in Years including Partial Year
    Headcount by Management Level
    Worker Data: Current Stating Information
    • Ending Headcount
    Headcount Growth and Analysis
    • Ending Headcount
    Workforce Tenure - Yearly Trend
    Worker Data: Current Staffing Information
    • Ending Headcount
  • Diversity Dashboard
    Security:
    Management Dashboard: Diversity
     domain in the System functional area.
    Worklet Name
    Domains
    Calculations
    Employee Population Trend by Gender
    Person Data: Gender
    • Ending Headcount
    Ethnicity / Management Level Analysis
    Person Data: Ethnicity
    Person Data: Ethnicity
    • Ending Headcount
    Male / Female Distribution
    Person Data: Gender
    • Ending Headcount
    Male / Female Workforce Majority by Country
    Person Data: Gender
    • Ending Headcount
    Manager Composition by Ethnicity and Years of Experience
    Person Data: Ethnicity
    Worker Data: Compensation by Organization
    Worker Data: Current Staffing Information
    • Ending Headcount
    • % Managers
    • Average compa-ratio
    • Average Years in Position
    People Manager Proportions
    Person Data: Gender
    • Ending Headcount
  • Headcount Movement Dashboard
    Security:
    Management Dashboard: Headcount Movement
     domain in the System functional area.
    Worklet Name
    Domains
    Calculations
    Hires by Age Group
    Person Data: Date of Birth
    • Hire Count
    Promotion Rate
    • Promotion Rates = Promotion Count / Ending Headcount
    Voluntary Terminations by Management Level
    Worker Data: Current Staffing Information
    Worker Data: Active and Terminated Workers
    • Voluntary Termination Count
    Quarterly Turnover Rates
    Worker Data: Active and Terminated Workers
    • Voluntary Turnover Rates = Sum Voluntary Termination Count / ((Ending headcount of previous period + ending headcount)/2)
    • Involuntary Turnover Rates = Sum Involuntary Termination Count / ((Ending headcount of previous period + ending headcount)/2)
    Employee Movement
    Worker Data: Organizations
    • Hire Count
    • Transfer In
    • Transfer Out
    • Termination Count
    • Ending Headcount
  • Performance and Potential Dashboard
    Security:
    Management Dashboard: Performance and Potential
     domain in the System functional area.
    Worklet Name
    Domains
    Calculations
    Retention for High Potential Employees
    Worker Data: Talent
    • Ending Headcount
    Avg. Compa-Ratio by Potential
    Worker Data: Talent
    Worker Data: Compensation Pay Range
    • Average Compa-ratio
    Avg. Compa-Ratio by Performance Over Time
    Worker Data: Performance Reviews
    Worker Data: Compensation Pay Range
    • Average Compa-ratio
    Management Level by Potential
    Worker Data: Current Staffing Information
    Worker Data: Talent
    • Ending Headcount
    Performance by Hiring Source
    Worker Data: Current Staffing Information
    Worker Data: Performance Reviews
    • Ending Headcount
    Terminations by Performance
    Worker Data: Performance Reviews
    • Terminations Count
  • Structure Dynamics Dashboard
    Security:
    Management Dashboard: Structure Dynamics
     domain in the System functional area.
    Worklet Name
    Domains
    Calculations
    Worker Proportion Trends
    Worker Data: Current Staffing Information
    • Manager Count
    • Employee Count = (Ending Headcount - Manager Count)
    Manager Headcount by Management Level
    Worker Data: Current Staffing Information
    • Ending Headcount
    Span of Control by Job Family Group
    Worker Data: Current Staffing Information
    • Average Span of Control (default displayed on charts) = (Ending Headcount - Manager Count) / Manager Count
    • Average Span of Control (Headcount to Manager) = Ending Headcount / Manager Count
    Span of Control by Range of Direct Reports
    Worker Data: Current Staffing Information
    • Manager Count
    Span of Control - Manager Outliers
    Worker Data: Public Worker Reports
    Worker Data: Current Staffing Information
    • Number of Direct Reports (~Employees~)