The Workforce Separation by Length of Work (Organization Hierarchy) Trend Analytics workbook compares the amount of time people have been with your enterprise, to the separation rate over time.

Business Questions

How long do employees tend to work for the enterprise? Does the length of service 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.

• Length of work band columns (one column per defined length of work band)

  The number of people who have separated from the workforce whose length of service matches the length of work band.

• Total

  The total number of separations for the time period.