How to find out Employee Attrition Rate for a particular department?
'Opening count' is the opening count of the employees, 'no. Of attritions' is the number of Employees left from the department and 'New Joined' is the number of Employees joined to the department.
UDDC Name : Attrition
UDDC Formula : ((no. Of attritions * 100) / (Opening count + New Joined)) /100.
e.g: Consider Opening count = 500, No. of attritions = 20 and New Joined = 35. According to the formula, the attrition rate will be 0.037 i.e. 3.7%.Tags: Employee, Attrition Rate, department, UDDC, formula, Business Intelligence Support, Business Intelligence Articles, Business Intelligence Training, crosstab, Geomap, Tabular, Graphs, Smarten View, Visualization, Opening Count, New Joined, User Defined Dimension Column, Attrition calculation, Employee turnover, Employee retention, Department metrics, Workforce analytics, Employee statistics, HR metrics, Workforce management, Attrition percentage, HR formula, Employee movement, Department performance, Employee loss, Employee joining rate, Workforce analysis, Formula-based calculation, HR reporting,
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article