In various trend reports, we calculate values based on data from employee profiles and employment records. Many widgets are straightforward, but some need a bit of extra explanation. On this page, you’ll learn how the key calculations in the trend reports work.
Note: When calculating the figures, we include all active and archived users. This ensures historical data is always correct, even when employees have since left.
Number of employees
This value shows how many employees are employed today. How we calculate it:
We select all colleagues with an active employment.
We count them.
Number of FTEs
This widget shows the total number of FTEs for employees who are employed today. How we calculate it:
We select all colleagues with an active employment.
For each employee, we calculate the FTE ratio:
hours per work schedule ÷ full-time hours from the company settingsWe add up all FTE ratios.
Example:
Full-time working week = 40 hours
User 1: 40 hours = 1 FTE
User 2: 20 hours = 0.5 FTE
User 3: 30 hours = 0.75 FTE
Total: 2.25 FTE (3 employees)
Average age
This widget shows the average age of employees who are employed today. How we calculate it:
We select all employees who are employed today.
For each employee, we determine the age based on the date of birth.
We calculate the average.
Age distribution
This widget shows how many employees fall within different age categories. How we calculate it:
We select all employees who are employed today.
We determine their age based on the date of birth.
We group the counts by category.
Nationality
This widget shows the distribution of employees based on the profile field nationality. How we calculate it:
We select all employees who are employed today.
We fetch their nationality.
We count all nationalities and group them.
Gender
This widget shows the distribution of employees based on the profile field gender. How we calculate it:
We select all employees who are employed today.
We fetch the gender.
We count and group the numbers by gender category.
Retention rate
The retention rate shows what share of employees stayed employed during a period. How we calculate it:
A = number of employees on the start date
B = number of employees from group A who are still employed on the end date
Retention rate = (B / A) × 100
Example:
A = 20 employees
B = 18 employees
Retention rate = 90%
Average time employed
This widget shows how long employees are employed on average. How we calculate it:
We select all employees with an employment start date before the report date.
For each employee, we determine the tenure up to the report date.
We calculate the average.
Turnover percentage
The turnover percentage shows what percentage of employees left in a period. How we calculate it:
A = number of employees on the start date
B = number of employees on the end date
C = average number of employees = (A + B) / 2
D = number of employees who left during the period
Turnover percentage = (D / C) × 100
Example:
A = 20
B = 22
C = 21 on average
D = 3 leavers
Turnover percentage = 14.3%
Inflow and outflow
This widget shows how many employees started and left within a given period.
Inflow = employees with a start date within the period.
Outflow = employees with an end-of-employment date within the period.
Average salary
This widget shows the average salary on the reporting date. How this is calculated:
We select all employees who are employed on that day.
We retrieve their salary as of that date.
We group the data by salary type.
We calculate the average.
Sick leave percentage
The sick leave percentage shows how many hours employees were sick in relation to their working hours. How this is calculated:
We select all employees who were (partially) employed during the selected period.
Per employee, we determine:
total number of working hours (based on the work schedule)
total number of sick leave hours
Per employee, we calculate:
sick leave percentage = (sick hours ÷ working hours) × 100We then calculate the average across all employees.
Conclusion
Trend reports provide valuable insights into the development of your organization. With this explanation, you know exactly how the figures are constructed.
Related keywords: trend report, trends, HR trends, HR reporting, trend chart, absenteeism trend, turnover trend, retention trend, salary trend, HR dashboard, analysis, employee analysis, widgets, HR widgets.