The Schedules - Average Scheduled Daily Hours report contains the calculated average daily hours that employees were scheduled for. Alternatively, you can configure the report to calculate average daily hours based on the number of calendar days contained in a specified date range (using the Schedule Period Start and Schedule Period End filters).
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Name Number | |||
| Scheduled Hours | Sum | ||
| Scheduled Days | |||
| Scheduled Day Average | |||
| Calendar Days in Period | |||
| Calendar Day Average | |||
| Hire Date | |||
| Days Employed at End of Period |
Custom Fields
Scheduled Days
The Scheduled Days custom field displays the total number of days in which employees are scheduled. It uses the following expression:
count(DISTINCT EmployeeSchedule.BusinessDate)
Scheduled Day Average
The Scheduled Day Average custom field displays the employee’s scheduled average daily hours, calculated by dividing their total scheduled minutes by their number of days scheduled. It uses the following expression:
sum(EmployeeSchedule.nethours)/count(DISTINCT EmployeeSchedule.BusinessDate)
Calendar Days in Period
The Calendar Days in Period custom field displays the total number of days in the report’s scheduled period (configured using the Schedule Period Start and Schedule Period End filters). It uses the following expression:
DATEDIFF(dd,@schedule_period_start,@schedule_period_end)
Calendar Day Average
The Calendar Day Average custom field displays the employee’s calendar average daily hours, calculated by dividing their total scheduled minutes by the number of calendar days in the period. It uses the following expression:
sum(EmployeeSchedule.nethours)/DATEDIFF(dd,@schedule_period_start,@schedule_period_end)
Days Employed at End of Period
The Days Employed at End of Period custom field displays the total number of days that employees were employed at the end of the report’s scheduled period. It uses the following expression:
DATEDIFF(dd,Employee.HireDate, @schedule_period_end)
Filters
The template includes the following filters: