Overview
Create a custom report to gain insights, fine tune your business, and schedule more efficiently. Use the integrated report builder to create as many custom reports as you need.
You can drag and drop columns right in the app to arrange the data exactly how you want. Additionally, you can filter, sort, and rearrange the data right in the app. Any refinements you make are preserved when you export your report.
Considerations
- The data available in the custom report is current as of the prior midnight in your account’s timezone. Any data from midnight until the current time will be reflected in the next day’s report.
- Data availability for the Shifts and Times report spans the past 3 months and 3 months into the future.
- Data availability for the Shift History report spans the past 60 days.
- Reports cover a 180 day duration period.
Reporting experience
The reporting experience within When I Work encompasses a few different types of reports and exports. Use the following links to explore each in more detail:
The data available in the custom report is current as of the prior midnight in your account’s timezone. Any data from midnight until the current time will be reflected in the next day’s report.
Creating Custom Reports
Check out Creating and Refining Reports for more information on creating a report.
Custom Reports page overview
Once you have created your report, you can refine the data within to analyze your business then export.
| Callout |
| Name |
| Description |
| a |
| Report Type |
| The report type you chose when creating the report. Click to generate a new or different report. |
| b |
| Date Range |
| The date range you chose when creating the report. Click to change the date range for the report. |
| c |
| Account |
| Name of the account the report is for. Click to change the account. |
| d |
| Filters |
| Use filters to narrow down data to specific people, places, and behaviors. |
| e |
| Columns |
|
Use the Columns sidebar to show or hide columns, reorder columns, and create a pivot of the data you are refining. The columns sidebar is divided up into:
|
| f |
| Search |
| Type here to search for the filter you want to find. |
| g |
| Column Heading |
| Each column heading can be dragged and dropped to arrange your report. Additionally, each column heading can be pinned, grouped, filtered, and autosized. |
| h |
| Reset |
| Click Reset to reset the modifications you have made to your report. |
| i |
| Export |
| Click Export to build your report and send to your email. |
| Callout | Name | Description |
| a | Report Type | The report type you chose when creating the report. Click to generate a new or different report. |
| b | Date Range | The date range you chose when creating the report. Click to change the date range for the report. |
| c | Account | Name of the account the report is for. Click to change the account. |
| d | Filters | Use filters to narrow down data to specific people, places, and behaviors. |
| e | Columns |
Use the Columns sidebar to show or hide columns, reorder columns, and create a pivot of the data you are refining. The columns sidebar is divided up into:
|
| f | Search | Type here to search for the filter you want to find. |
| g | Column Heading | Each column heading can be dragged and dropped to arrange your report. Additionally, each column heading can be pinned, grouped, filtered, and autosized. |
| h | Reset | Click Reset to reset the modifications you have made to your report. |
| i | Export | Click Export to build your report and send to your email. |
Report types
Shifts report
Use the Shifts report data to understand how managers and employees are interacting with their schedule. For example, you can:
- See which OpenShifts aren’t being filled
- View scheduled hours by schedule, position, and job site
- View shifts from all schedules in one report
- Identify no shows (blank time entry)
Check out a detailed list of fields.
Times report
Use the Times report to compare employees’ time entries to scheduled shifts as well as determine patterns of behavior that might contribute to attendance issues. You can also dig into more detailed clock in and clock out information not visible elsewhere in When I Work.
Check out a detailed list of fields.
Shift History report
Use the Shift History report to trace shift changes that can help resolve labor disputes, hold employees and schedule managers accountable for their actions, and identify patterns of behavior over time. For example, you can:
- Determine when shift edits are taking place
- Investigate employee shift confirmation behavior
Check out a detailed list of fields.
Working with reports
Check out the following articles to learn more about how to work with the reporting tool as well as view some example scenarios within each report: