Employee Interview Availability/Scheduled/Total Hours - Long Format Report
Table of Contents
This detailed report shows the number of hours of available, scheduled/busy, and total time by user. The long format helps more with data applications (loading the report into Excel/Google Sheets or other systems) while wide format is easier to read. The date range limit on this report is a maximum of 14 days ahead.
Report fields
Available filters are highlighted below.
| Field | Field Description | Sample Value & Formatting |
|---|---|---|
| User Name | Returns the full name of the user. | Jane Smith |
| User Email | Returns the user’s email address. | janesmith@clientemail.com |
| User ID | Returns the user’s user ID, if populated. | J2495763 |
| Role Name | Returns the user’s role. | Edit everything |
| User Job Title | Returns the user’s job title. | HR Advisor |
| User Time Zone | Returns the user’s time zone. | (UTC-04:00) US/Eastern |
| Type |
Returns the type of calendar time that is being checked for the user. Options include:
|
Scheduled/Busy |
| Date Fields |
Based on the date range used on the report, the columns will be set dynamically. So with a date range of 04-06-2025 through 04-09-2025, I would have 4 columns to show availability hours per user.
Example fields and values shown below. This report has a maximum range of 7 days.
|
See description |
| Day of the Week | Returns the day of the week that the user is available/busy/total for interviews on this day based on the Type field. | Wednesday |
| Number of Hours | Returns the number of hours that the user is available/busy/total for interviews on this day based on the Type field. | 3 |