What metrics from Sympa HR are available by default? – Dear Lucy

Sympa HR metrics in Dear Lucy dashboards

Please note that sick days, as seen Sympa HR, is not accessible through the Sympa HR's API. Dear Lucy dashboards instead show weekday absences.

In addition to the metrics listed below, the default dropdown filters available in the Sympa HR Dashboards are Employees by: Country, Company, Contract type, Location, Team, Department, Business Unit and Gender. These filters will work automatically, as long as the data is transferred to Dear Lucy over the API.

	Metric title	Widget type	Type of data	Time period	Description
1	Number of employees	Overview	Number	This month	Shows the sum of all employees that have a start date, and without an end date, up until the current calendar month. Employees without a start date will not be counted.
2	Number of employees by month	Bar chart	Number	By month, this year	Shows the number of active employees (with a start date but no end date) by month over the year.
3	New employees this month	Overview	Number	This month	Shows the sum of all employees with an initial start date in the current calendar month.
4	New employees per month	Bar chart	Number	By month, this year	Shows the sum of all new employees by initial start date, by month, over the year.
5	Unwanted leavers this year	Overview	Number	This year	Sums up all leavers (employees with an end date) marked as unwanted, from the start of the year to current date.
6	Leavers per month	Bar chart	Number	By month, this year	Sums up all leavers (employees with an end date) by month, over the year.
7	Leavers this year	Overview	Number	This year	Sums up all leavers (employees with an end date) within the current year.
8	Leavers by reason (%) YTD	Pie chart	Percentage (%)	This month	Shows the % of leavers (with an end date up to the current date) by different reasons (as filled in in source system).
9	Personnel turnover by month	Bar chart	Percentage (%)	By month, this year	12-month average. Formula: Total number of leavers in the period / ((number of employees at start of period + employees at end of period) / 2)
10	Average contractual working hours by month	Bar chart	Number	By month, this year	Shows the average contractual amount of weekly working hours per employee.
11	Cumulative weekday absences this year	Bar chart	Number	By month, this year	Sum of the number of weekday absences of all employees, as marked as absence in the source system. The absence interval may include public holidays, as it counts calendar days (not working days).
12	Employees per contract type (%)	Pie chart	Percentage (%)	Current state, this month	Shows the share, and number, of current employees by type of contract (e.g. permanent or fixed-term).
13	Weekday absences this month	Overview	Number	This month	Shows the absence days of all employees, as marked as absence in the source system. The absence interval may include public holidays, as it counts calendar days (not working days).
14	Weekday absences this year	Overview	Number	This year	Shows the cumulative number of absence days of all employees, as marked as absence in the source system. The absence interval may include public holidays, as it counts calendar days (not working days).
15	Unwanted leavers	Overview	Number	This month	Sums up all leavers (employees with an end date) marked as unwanted leavers this calendar month.
16	Leavers	Overview	Number	This month	Shows all leavers (employees with an end date) within the calendar month.
17	Employees by contractual working hours (%)	Pie chart	Percentage (%)	Current state, this month	Shows the percentage and number of employees by their contractual amount of weekly working hours (e.g. part-time, full-time, etc.).
18	Weekday absences per month	Bar chart	Number	By month, this year	Shows the absence days of all employees per month, as marked as absence in the source system. The absence interval may include public holidays, as it counts calendar days (not working days).
19	Unwanted leavers per month	Bar chart	Number	By month, this year	Shows all leavers (employees with an end date) marked as unwanted leaver, by month.
20	Personnel turnover	Overview	Percentage (%)	This month	12-month average. Formula: Total number of leavers in the period / ((number of employees at start of period + employees at end of period) / 2)
21	Average contractual working hours	Overview	Number	This month	Shows the average contractual amount of weekly working hours per employee, this month.
22	Cumulative leavers	Bar chart	Number	This year	Shows the cumulative sum of all leavers (employees with an end date) by month this calendar year.
23	Cumulative unwanted leavers	Bar chart	Number	This year	Shows the cumulative sum of all leavers (employees with an end date) marked as unwanted leaver, by month this calendar year.
24	Avg employment duration	Overview	Number	Current state, this month	Shows the current state of the average employment duration based on initial start date and end date.
25	New employees this year	Overview	Number	This year	Shows the sum of all employees with an initial start date this current calendar year.
26	Age distribution	Vertical bar chart	Number	Current state, this month	Shows the distribution of employees by age and gender, based on birth dates and gender selections in the source system.
27	Employees by location (%)	Pie chart	Percentage (%)	Current state, this month	Shows the distribution of employees by location, as marked in the source system.
28	Male / Female (%)	Pie chart	Percentage (%)	Current state, this month	Shows the distribution of employees by gender, gender selections in the source system.
29	Cumulative new employees this year	Bar chart	Number	By month, this year	Shows the cumulative sum of all employees with an initial start date this current calendar year, by month, with last year as a line.

Please download the attached Excel file for an even more detailed description of the available HR metrics, including from which tables in Sympa the data is coming from.

HR Dashboards specs.xlsx
10 KB Download