The Workforce Count by Job Category (Organization Hierarchy) Trend Analytics workbook calculates the Workforce Measurement Value (Head Count or FTE) of your workforce, broken down by job category, for each time period within the given date range.

Business Questions

How does the total number of employees, broken down by job category, 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 worksheets display one row for each time period for each job category. For example, the by Month worksheet displays one row for each month for each job category.

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".

• Date

  The start date of each time period.

• Job Category

  Lists the job categories that exist within each time period.

• Workforce Measurement Value

  The total Headcount or Full Time Equivalent (depending on your selection in the worksheet parameter) for each job category at the start of each time period.