The Workforce Count (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating workforce losses that occur within yearly periods, the other providing a detailed analysis of the losses within yearly periods.
These worksheets help you to create reports to analyze how your workforce is changing. For an explanation of how workforce count is calculated, see: Workforce Calculation
The template includes the following mandatory parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations - Yes/No
Workforce Measurement Type
The template includes the following optional parameters:
Geography Area
Geography Country
Geography Region
Geography Location
Job Category
Job
Grade
Position
This template workbook has the following worksheets:
By Year
Details
The by Year worksheet analyses how your workforce fluctuates over time.
It displays one row for each year within the start and end dates you selected in the worksheet parameters.
The worksheet contains the following columns:
Year
Date
The start date of the year.
Workforce Measurement Value
The total workforce count for each year (the returned value depends on the workforce measurement value you selected in the worksheet parameters).
The Detail worksheet tells you how your workforce fluctuates across different groups within your organization, such as organization, job, and location. You view the detail for one year at a time.
Use the Year page item in the worksheet to select the year you are interested in.
The worksheet displays one row for each organization, location, job, grade, and position.
The worksheet contains the following columns:
Organization
The organization that had the gain.
Location
The location where the gain took place.
Job
The job of the gain.
Grade
The grade of the gain.
Position
The position of the gain.
Workforce Measurement Value
The total workforce count for each of the above groups (the returned value depends on the workforce measurement value you selected in the worksheet parameters).