Measures

Measure Description Analyze by date
Average Employee Count Sum of employee counts for the selected period divided by the number of months in the selected period.
YTD Average Employee Count Year to date average employee count for the year of the selected period up to and including the selected period.
'Avg ' + GetPromptValue('Employee Count or FTE','Employee Count') Average of employee count or the average of FTE count W.R.T the parameter filter option used in the dashboard.
Average Employee Count By Snapshot_Month
Avg Employee Count By Snapshot_Month
Avg Employee Count By Snapshot_Month
Employee Count A 1 for every Employee + Active Work Assignment pair for the selected snapshot month. Employee with 3 active Work Assignment will count as 3 for this measure. By Snapshot_Month
Distinct Employee Count - YAGO Year Ago Count - Distinct count of employee with an active work assignment. For example, for employee having 3 active work assignment, the distinct employee count will be 1. This includes employees that started or were terminated in the month. By Snapshot_Month
Distinct Employee Count - TTM Distinct count of employee with an active work assignment in a snapshot month. For example, for employee having 3 active work assignment, the distinct employee count will be 1. This includes employees that started or were terminated in the month. By Snapshot_Month
Distinct Employee Count Distinct employee count by HR Organization and Employee ID for snap shot month. Employees who started or termed are included. By Snapshot_Month
Employee Count MAGO Month Ago, Count - A 1 for every Employee + Active Work Assignment pair for selected period. Employee with 3 active work assignment will count as 3 for this measure. By Snapshot_Month
Employee Count YAGO Year Ago, Count - A 1 for every Employee + active work Assignment pair for selected period. employee with 3 active work assignment will count as 3 for this measure. By Snapshot_Month
Distinct Employee Count MAGO Month Ago Count - Distinct employee count by HR organization and employee ID for snap shot month. Employees who started or termed are included. By Snapshot_Month
Employee Count TTM Count of every employee with a active work assignment for the Trailing Twelve Months or TTM prior to the selected period. By Snapshot_Month
GetPromptValue('Employee Count or FTE','Employee Count') Average Of Employee Count or the average of FTE count based on the parameter filter option used in the dashboard.
Employee Count Overall distinct employee count while only considering the employees with active work assignment.
Adjusted LOS Employee's length of service based on their adjusted start date for selected snapshot month. By Snapshot_Month
LOS Employee's length of service in years, based on the difference between the employee's start date and the snapshot month which is the effective from month. Length of service is the number of years an employee has been working for an organization. By Snapshot_Month
LOS TTM Sum of the length of service in months, based on the difference between the employee's start date and snapshot month for the Trailing Twelve Months or TTM to the selected snapshot month. By Snapshot_Month
LOS MAGO Length of service in years, based on the difference between the employee's start date and one month ago or MAGO from the selected snapshot month. By Snapshot_Month
LOS YAGO Length of service in years, based on the difference between the employee's start date and one year ago or YAGO from the selected snapshot month. By Snapshot_Month
Seniority LOS Employee's length of service based on the difference between their seniority date and the snapshot month seniority LOS is the length of time an employee has been employed, starting from their most recent date of hire. By Snapshot_Month
Supervisor Count Distinct count of supervisor codes. By Snapshot_Month
Employee Per Supervisor Number of employees or number of supervisor codes.
Fact Employee WA Action Key - Count Distinct By Effective To
Fact Employee WA Action Key - Count By Effective To
Fact Employee WA Action Key - Count Distinct By Effective From
Fact Employee WA Action Key - Count By Effective From
Average FTEs Average FTE's for the employees for the year of the selected period up to and including the selected period.
FTE Total Sum of FTEs per Employee for all of their Work Assignment. By Snapshot_Month
FTE TTM Sum of FTEs for the trailing twelve months or TTM from the selected period. By Snapshot_Month
FTE MAGO Sum of FTE for the period one month prior or MAGO to the date selected. By Snapshot_Month
FTE YAGO Sum of FTEs for one year ago or YAGO from the selected period By Snapshot_Month
Distinct Work Assignment Count Distinct count of work assignments By Snapshot_Month
Distinct Work Assignment Count TTM Distinct count of work assignments for the Trailing Twelve Months or TTM prior to the selected period. By Snapshot_Month
Distinct Work Assignment Count MAGO

Distinct count of work assignments for one month ago or MAGO prior to the selected period.

 By Snapshot_Month
Time in Position The difference in years, between the position effective date and the snapshot month. By Snapshot_Month
Time in Job The difference in years between the job effective date and the snapshot month. By Snapshot_Month
Distinct Work Assignment Count YAGO Distinct count of year ago work assignments. By Snapshot_Month
Work Assignment Count The work assignment count of the employee.
Termination Numerator