Employee metrics

The following metrics are used in most Human Resources analytics, and appear particularly in the Workforce analysis reports. See the object definition for details. (Open MicroStrategy Developer, navigate to the Human Resources Analysis Module, navigate to the metric you are interested in, and double-click the metric to see details.)

Metric/KPI	Description	Formula
Employees - Current	Total number of employees currently working for the company.	Count(Employee) {~} <[Active Employee (Current)]>
FTE	Number of full-time equivalent employees.	Sum([FTE Coefficient]) {~}
Contractors	Number of contractors working for the company.	Count(Contractor) {~, Time} <[Active Contractor]>
Avg. Current Tenure (months)	Average of employees' current tenure (at a level higher than employee).	Avg([Current Tenure]) {~}
Departed Employees - Current	Number of employees who left the company.	Count(Employee) {~} <[Inactive Employee (Current)]>
Involuntary Departed Employees - Current	Number of employees who involuntarily left the company.	Count(Employee) {~} <[Involuntary Departed and Inactive Current]>
Voluntary Departed Employees - Current	Number of employees who voluntarily left the company.	Count(Employee) {~} <[Voluntary Departed and Inactive Current]>
Employees - All Identity Groups	Number of employees with no grouping on gender and ethnicity, and with filtering set to Ignore.	Count(Employee) {Gender, Ethnicity} <[Active Employee (Current)]>
Contribution to Identity Group	See formula to the right.	(([Employees - Current] * 1.0001) / ([Employees - All Identity Groups] * 1.0001))
Contractors (for Access outer join)	Number of contractors working for the company.	Count(Contractor) {~, Time} <[Active Contractor]>
Employees with Minority Group	Total number of employees working for the company who belong to a minority group.	Count(Employee) {~, Time} <[Active Employees with Minority Group (Hist)]>
Employees with Minority Group to Employee Base	Number of employees with a minority group, divided by the total number of employees.	(((1.001 * [Employees with Minority Group]) / Employees) * 1.001)
Employees with Minority Group to All Employees	Number of new employees with a minority group, divided by the total number of employees.	(((1.001 * [New Employees with Minority Group]) / Employees) * 1.001)
Minority Group Hiring Score	See formula to the right.	(((1.001 * [New Employees with Minority to All New Employees]) / [Employees with Minority Group to Employee Base]) * 1.001)
Involuntary Departed Employees with Minority	Total number of involuntarily departed employees who belong to a minority group.	Count(Employee) {~} <[Involuntary Departed Employees with Minority]>
Involuntary Departed Employees with Minority Group to All Involuntary Departed Employees	See formula to the right.	((1.001 * [Involuntary Departed Employees with Minority]) / ([Involuntary Departed Employees] * 1.001))
Minority Group Involuntary Departure Score	See formula to the right.	(((1.001 * [Involuntary Departed Employees with Minority to All Involuntary Departed Employees]) / [Employees with Minority Group to Employee Base]) * 1.001)
Employees	Total number of employees working for the company during a particular month.	Count(Employee) {~, Time} <[Active Employee (Hist)]>
Departed Employees	Total number of employees who left the company in a certain month.	Count(Employee) {~} <[Departed Employees (Hist)]>
Involuntary Departed Employees	Number of employees who involuntarily left the company in a certain month.	Count(Employee) {~} <[Involuntary Departed Employees]>
Voluntary Departed Employees	Number of employees who voluntarily left the company in a certain month.	Count(Employee) {~} <[Voluntary Departed Employees]>
Attrition Rate	See formula to the right.	((1.0001 * [Voluntary Departed Employees]) / (1.0001 * (Employees + [Voluntary Departed Employees])))
Turnover	See formula to the right.	([New Employees] - [Departed Employees])
Turnover Rate	New and departed employees, divided by the total number of employees.	(((1.001 * ([New Employees] + [Departed Employees])) / Employees) * 1.001)
Transferee Turnover Rate	New, departed, and transferred employees, divided by the total number of employees.	(((1.001 * (([New Employees] + [Departed Employees]) + [Transferred Employees])) / Employees) * 1.001)
Tenure (months)	Employee tenure.	Max(Tenure) {~}
Avg. Tenure (months)	Average employee tenure.	Avg(Tenure) {~}
Avg. Executives' Tenure (months)	Average executive tenure.	Avg(Tenure) {~} <[Active Executives (Hist)]>
New Employees	Total number of employees who joined the company in a selected month and whose tenure is only one month.	Count(Employee) {~} <[Tenure = 1]>
New Employees with Minority Group	Total number of new employees who belong to a minority group.	Count(Employee) {~} <[Tenure =1 and Minority Group]>
New Employees with Minority to All New Employees	Number of new employees with a minority group, divided by all new employees.	(((1.001 * [New Employees with Minority Group]) / [New Employees]) * 1.001)
Hiring Rate	See formula to the right.	((1.0001 * [New Employees]) / (1.0001 * Employees))
Full-time Employees	Number of full-time employees working for the company (flag on Position Status = Full Time).	Count(Employee) {~, Time} <[Full-time and Active (Hist)]>
Part-time Employees	Number of part-time employees working for the company (flag on Employment Status = Part-time).	Count(Employee) {~, Time} <[Part-time and active (Hist)]>
Executives	Number of executive-level employees working for the company.	Count(Employee) {~, Time} <[Active Executives (Hist)]>
Executives to All Employees Ratio	See formula to the right.	((Executives * 1.0001) / (Employees * 1.0001))