The Workforce Separation by Reason (Organization Hierarchy) Trend Analytics workbook enables you to investigate the different reasons why your enterprise is losing workforce over time.

Business Questions

Why are employees leaving my enterprise? Do the leaving reasons change over time?

Workbook Parameters

You must enter a value for the following parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

Use the following optional parameters to further restrict the values in the workbook:

• Geography Area

• Geography Country

• Geography Region

• Geography Location

• Job Category

• Job

• Grade

• Position

Worksheets

This workbook has the following worksheets, each representing a time period, or a time period and another structure:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

The worksheet matrix reports display one row for each time period. For example, the by Month worksheet displays one row for each month.

Workbook Headings and Calculations

The matrix reports contain the following columns:

• A time period column

  The heading depends on the selected worksheet, for example, in the by Month worksheet, this column is named "Month".

• Start Date

  The start date of each time period.

• End Date

  The end date of each time period.

• Leaving reason columns (one column per defined leaving reason, divided into voluntary and involuntary leaving reasons)

  The number of people who have separated from the workforce for the leaving reason for each time period.

• Blank

  The number of people who have separated from the workforce, with no associated leaving reason for each time period.

• Total

  The total number of separations for the time period.