Schedule - Summary by employees 🔗
This panel shows the average of the selected days and the breakdown of data by employee.
- Name of the employee.
- Group to which the employee belongs.
- Active range: average daily presence time of this employee for the selected days.
- Breaks: average daily break time of this employee for the selected days.
- Activity: average daily activity of this employee for the selected days.
- Expected: the expected daily activity previously configured in the group to which the user belongs.
- Activity – Expected: obtained by subtracting the average daily activity minus the average daily expected. If the value is greater than 0, it indicates overtime worked by the employee. If the value is less than 0, it indicates the time the employee owes the company.
This panel also allows us to “group the data” so that only information from the groups is shown. If we group data instead of viewing user averages, the graph will show the 3 groups above the average and the 3 groups below the average.
- Group to which the employee belongs.
- Active range: average daily presence time of this group for the selected days.
- Break: average daily break time of this group for the selected days.
- Average activity: average daily activity of this group for the selected days.
- Expected: the expected daily activity configured for this group.
- Activity – Expected: average daily activity – average expected. If the value is greater than 0, it indicates overtime worked by the group. If the value is less than 0, it indicates the time the group owes the company.
In the “Summary by employee” panel table, you will now find absolute values for the time period of activity, productivity, expected, and difference.
Effective work can be calculated based on activity or based on productivity.
When effective work is based on productivity, the chart shows a comparison of the last two weeks of expected, activity, and productivity.
When it is based on activity, it will only show expected and activity.
Schedule - Detail 🔗
In this panel we show daily totals and the breakdown of data by employees and days.
- Name of the employee.
- Date: specific day.
- Start: time of the first event of the day (usually the PC startup).
- End: time of the last event of the day (usually the PC shutdown or log off).
- Active range: presence time. Calculated by subtracting the start time from the end time.
- Activity: sum of hours of PC activity and offline activity.
- Productivity: sum of total productivity hours for the selected date filter and group.
- Breaks: total time during which no activity was reported during the day.
- Expected: the expected daily activity configured in the group to which this user belongs.
- Activity – Expected: average daily activity – average daily expected. If the value is greater than 0, it indicates overtime worked by the employee. If the value is less than 0, it indicates the time the employee owes the company.
- Productivity over expected: level of achievement of the expected productivity goal for the group, calculated by dividing the average productivity of that group by the expected time.
In the Schedule Detail panel, you can also view data related to activity.
By default these fields are hidden, but the activity columns can be shown by clicking the "Columns" button and selecting them.
In this panel you will find all the necessary information for preparing the monthly employee report required by the Labor Inspectorate.
As in all software panels, you can export this data in various formats (PDF, CSV, and Excel). When exporting to Excel, the data appears in hours and seconds. To convert them into hours, simply add a new column next to the data you want to convert and divide by 3,600.
To print a report for a specific employee, you should select that employee, the start and end date of the month in the filter, and export it to PDF.
Data visualization
It is now also possible to sort data by more than one column; you can do this by pressing the Shift key and the column headers you want to use for sorting. You can do this in all panels that have repeated sections like HorarioDetalle.
Inside the “Detail” panel of the “Schedule” section, when filtering by an employee, it is now possible to view the total times of activity, breaks, and waiting.
Visual schedule - By groups 🔗
The tables contain expandable and collapsible sections to facilitate reading and understanding of the displayed data. Data can be expanded by group and subgroup, according to the information you want to view; you can also select to see the active range of groups or work departments in your company.
Visual schedule - Detail 🔗
The graph shows us day by day the start and end hours of the activity. The actual activity is shown in orange, breaks taken in gray, and weekend inactivity in light blue. The sum of both colors gives us the total active range. Only breaks that exceed the minimum time considered as a break by the administrator (by default, 5 minutes) are shown.
The arrows allow us to move from one employee to another. We can also select the employee we want from the dropdown.