The Workforce Separation by Reason (Organization Hierarchy) Status Analytics workbook investigates the different reasons for separations within groups such as organization, geographical area, and separation category. You can determine if employees in different groups leave your enterprise for different reasons.

Business Questions

Why are employees leaving my enterprise? Do the leaving reasons vary between employee groups?

Workbook Parameters

All worksheets in this workbook have the following mandatory parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

Use the following 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 grouping within your organization:

• By Organization

• By Geography Area

• By Separation Category

The worksheets display one row for each group. For example, the by Organization worksheet displays one row for each organization.

A Total row returns the total number of separations for each leaving reason.

Headings and Calculations

The matrix reports contain the following columns:

• A grouping column

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

• Leaving reason columns (one column per defined leaving reason)

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

• A blank column

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

• Total

  The total number of separations during the selected time period for each worksheet grouping.