To calculate absenteeism rate, follow these steps:
Determine the number of absences during the time period you are measuring. Divide this number by the total number of scheduled workdays during the same time period. Multiply this number by 100 to get the absenteeism rate as a percentage. Here is the formula:
Absenteeism rate = (Number of absences / Total number of scheduled workdays) * 100%
Example:
Number of absences = 10
Total number of scheduled workdays = 200
Absenteeism rate = (10 / 200) * 100% = 5%
Absenteeism rate is a useful metric for tracking how often employees are absent from work and for identifying areas where improvement is needed. By tracking absenteeism rate, companies can improve their employee attendance and reduce the costs associated with absenteeism.
...
1- تحميل بيانات غياب الموظفين HR-KPI_Employee.csv
=(COUNT(B2:B500) / 313)*100
النتيجة: 159.4249201%
...
...
SELECT (count(Date) / 313)*100 FROM `kpi_data.Absence`
النتيجة: 159.4249201%
...
...
(COUNT([Employee Id]) / 313) * 100
النتيجة: 159.4%
...
...
(nrow(Employee['Employee_Id']) / 313) *100
النتيجة: 159.4%
...
...
(Employee['Employee_Id'].count() / 313) * 100
النتيجة: 159.4%
...