As an admin, you can generate a customized report with both regular and split shift details. The split shift report provides session-wise attendance details and the regular shift report generates day-wise details. To generate the split shift report using Query Builder, the admin must perform the following actions:
- From the greytHR Admin login, navigate to Reports > Query Builder. The Query Builder page opens.
- Click the +Create Report button. A form opens.
- Under the Choose Fields section, from the Available Fields dropdown list, select the Basic Information category to add the basic employee details. And the Attendance Info category to add details such as Shift Name, Last Out Date Time Session 1, Last Out Date Time Session 2, Actual Hours, Attendance Date, Shift End Time Session 1, and Shift End Time Session 2 to your report.
- Select the required field name and click ⇾ to move the selected field under the Output Fields section.
Note: To move the selected field back under the Available Fields section, click ⇽. You can also click × against the selected field to remove the field. - Click Next. The Sort Order section opens.
- From the Output Fields section, select the fields one by one and click ⇾ to move the selected fields.
- Click the ↑ or ↓ to arrange the fields as per your preferences.
- Click Next. The Filter Criteria section opens.
- Under the Quick tab, from the Category Type dropdown list, select the required category. A list of all the relevant fields appears.
- Select the required category and click → to move the fields to the right column.
- To create a custom category, click the Custom tab. You can use the custom options to create a custom filter, such as joined date, employee name, and employee number.
- Click Next. The Results section opens.
- In the Report Title text box, enter the name of the report.
- In the Description text box, enter the description of the report.
- From the Employee Filter dropdown list, select the required option.
- Select the Accessible for all user checkbox to make the report accessible for all users.
- Select the Select users to allow them to edit the report checkbox, if necessary.
- Click Export to view or download your report in Excel format.
- Click Save Report to save the new report. The new report appears on the Query Builder page.
Note: You can edit the report by clicking the report name. You can also delete a report using the Delete icon available next to the report name.
Was this article helpful?
Related Links:
❓FAQs- To read more FAQs about the greytHR split shift, click here.
📃Documentation- To learn more about the Generate split shift report page, click here.
▶Video- To watch the video on Query Builder, click here.
📢Product Update- To read about the product update, click here.