🎯 This article is for expert admins.
Get familiar with using Shift types to make full use of this feature.
If you are using Shift types on the schedule, you can use the Shift type statistics report found under the Reports tab to view all kinds of data, such as sickness, late punches and overtime.
You can also download Schedule statistic reports and see how many hours your employees work or how many shifts they have in a specific period and in different Employee groups or Departments.
View reports based on Shift type statistics
With a well-organised use of Shift types, you can pull insightful reports detailing sick leave, productive or unproductive hours, or any other criteria that you have used Shift types for.
To view a report based on Shift types, go to Reports > Shift type statistics.
You can set your report criteria here and press Show Statistics to view an overview.
Shift types - Uncheck the box for All Shift types to select the specific Shift type(s) you want to report on. For example, select the shift type that you use to mark sickness.
Employees - Choose between Employees, Employee groups, and Departments to drill down further.
Range - Set the date range and days in the date range you want to be included.
Filter:
Except - Select a holiday calendar if you wish to exclude days from that calendar in your report.
Status - Filter based on All, Approved or Not approved shifts.
Include 0% If you want employees without activities of the selected type to be included in this report.
⚠️ Note, for Employee groups and Department statistics, percentage rates are always based on all employees in the selected group or department.
Check Show with the calendar to see when each Shift type was used per employee.
Press Show Statistics to view a report.
Use cases for Shift type statistics
Illness/Absence reports
If you have applied a Shift type for illness or absence, you can use this to view a tailored report. For example, you can generate a report on your Shift type, per department, per calendar month.
Punctuality reports
By assigning a late arrival Shift type to employees, you can use this to keep track of punctuality records over a given time period.
Overtime reports
By assigning a shift type to overtime, you can track how many hours your employees are working overtime and assess its impact on your revenue.
Download Schedule statistics reports
You can download Schedule statistics reports in Excel if you want further to analyse the Schedule data from your Planday account. There are two built-in reports:
Hours per employee - See how many hours your employees work in a specific period and in different Groups and Departments.
Shifts per employee - See how many shifts your employees are working in a specific period and in different Groups and Departments.
Go to Reports > Schedule statistic reports and select the report you wish to download, and press Generate report.
Based on your choice of report, you can customise the settings according to your requirements.
Select employees via employee list, Department list or Employee group list. You can also select if the report should include active or deactivated employees.
Select a date range and work days within the range to include in your report.
Include Shift types to choose which Shift type(s) you want to use in your report.
Filter for All, Approved (default), or Not approved Shifts.
You can choose between including Normal shifts or ignoring them from the report. (default On)
(Only in Hours per employee report) You can choose to include breaks or subtract break data from the report. (default Off)
(Only in Shifts per employee report) - Choose if you wish to include All shifts or shifts with Schedule time with/without start and end. These are any Extra shifts the employee may have taken that were not part of the schedule.
You can use custom balance filters to generate a report that matches your criteria. For example, Only include hours/shifts if the shift duration is greater than or equal to a specific number of hours.
Include all employees (default ON) who do not have shifts in the selected period.
Press Download report to download the Excel file based on your selected criteria.
With the data opened in Excel, you can use all the tools available in Excel to filter, create charts, and analyse your data down to the exact detail. See below an example report on Hours per employee.
See related articles:
ℹ️ Need more help?
🔍 Search the Help Center | See videos at Tutorials.Planday.com
💬 For personalised support
Log in and contact support using the blue icon at the bottom for further questions.