The Workforce Count (Organization Hierarchy) Trend Analytics workbook calculates the Workforce Measurement Value (Head Count or FTE) of your workforce for each time period within the given date range.

You can access this workbook from the Human Resources Intelligence - End User Self-Service menu.

Business Questions

How does the total number of employees in my enterprise change over time?

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 time period, or a time period and another structure:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

• By Year and Organization

• By Year and Geography

Most worksheets display one row for each time period. For example, the by Month worksheet displays one row for each month. However, the by Year and Organization worksheet displays one row for each year per organization, and similarly the by Year and Geography worksheet displays one row for each year per geographic area.

Workbook Headings and Calculations

The worksheets 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.

• Organization

  Appears only in the by Year and Organization worksheet.

• Area

  Appears only in the by Year and Geography worksheet.

• Workforce Measurement Value

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