Summary

Workday provides several tools for analyzing turnover by region and time period. Workday People Analytics includes a "Retention and Attrition" topic that explores turnover trends, identifying where and why workers are leaving. Specific worklets like "Trending Terminations by Location" and "Trending Terminations by Organization" display termination trends over time for different locations and organizational structures. The "Attrition Prediction report" in Workday Peakon Employee Voice can also help identify reasons for attrition in high-turnover areas.

For custom reporting, you can use data sources like "Organizations I Support or Manage (with inactive organizations)" to get turnover counts by location/region. Calculated fields can be created for headcount and terminations. To analyze turnover over a specific date range, you can use prompts for start and end dates in custom reports. The "Trended Workers" data source has built-in prompts for time series analysis and allows slicing data by location. A "Trended Turnover Summary" matrix report can also be copied and modified to analyze turnover by various dimensions, including region and time period.

Retrieved From Workday Documentation

From Workday

1. Turnover Analysis by Region and Time Period
   • Workday People Analytics includes a "Retention and Attrition" topic that explores business questions related to why workers are leaving and how to improve retention
     2.
   • The "What are the key turnover trends?" business question reveals turnover trends in the workforce impacting the overall attrition rate
     2.
   • The "Who is leaving?" business question surfaces areas in the company where workers are leaving and possible reasons
     2.
   • The "Trending Terminations by Location" worklet displays a line graph representing the trend of terminations in the 5 biggest locations over time for the organization
     3.
   • The "Trending Terminations by Organization" worklet displays termination counts in selected organizations and time ranges, including involuntary, regrettable, and voluntary termination types
     3.
   • The "Attrition Prediction report" in Workday Peakon Employee Voice can identify attrition reasons in areas with high turnover
     5.

From Customers

1. Turnover by Location/Region
   1
   • To get turnover count by location/region, you can use the data source "Organizations I Support or Manage (with inactive organizations)".
     1.2
   • Create calculated fields for headcount (using a Custom Report off the "Employees" field and an LVAOD calculation for starting and ending headcount) and terminations (using a Custom Report off the "Terminations" field).
     1.2
   • To get this month-wise over the last 2 years, you would need to adjust the approach.
     1.3
2. Turnover by Department and Location within a Date Range
   4
   • For a custom report to see turnover data by cost center and location for a given period, you can use "Prompt Date 1" and "Prompt Date 2" to define your date range.
     4.1
   • These dates can be used to calculate the number of months in the specified range and an "average ending headcount" to calculate the termination rate.
     4.1
   • The "Trended Workers" data source comes with built-in prompts for "Time Series Start Date" and "Time Series End Date" which can be configured under the Prompts tab.
     4.5
   • To slice by Location, add "Location" as a dimension under the Drill Down tab.
     4.5
   • If you want to see everything in one period based on the start and end date, consider using a Matrix report (not trending) and group on Location or Cost Center that is not period. However, this method will not allow you to pull in opening headcount.
     4.5
   • An alternative is to do rolling 12 headcount and use that as the base for a more normalized turnover rate.
     4.6
3. Employee Turnover Report by Company, Region, Manager, Job Type
   6
   • You can copy the matrix report called "Trended Turnover Summary" and then remove or replace fields as needed to drill down.
     6.1