This article covers Data Explorer in detail. For a quick introduction, see [Data Explorer].
Navigating This Article
View Details
Compliance Audit
Shows: Every labour compliance warning raised, including the warning, its category and source, the related scheduled and worked shifts, breaks taken, compliance hours and cost, and whether (and why) it was dismissed.
Default grouping: Store > Employee
Can group by: Store, Employee, Scheduled Shift, Worked Shift, Shift Date, Warning Category, Warning Title, Dismissal Reason
Employee Performance
Shows: One row per employee for the selected period, covering absences, lateness, no-shows, attendance %, shifts scheduled and worked, unscheduled shifts, shifts dropped, swapped and picked up, hours worked, leave requested and approved, commendations and disciplinary actions.
Default grouping: None
Can group by: Store, Employee
Note:
Terminated employees are always excluded.
Employees on a leave of absence or pending rehire are included.
Shifts worked at both home and shared stores are counted.
Payroll Readiness
Shows: Hours and pay for each pay period, down to the individual shift. This includes scheduled vs. worked hours, hours and cost variance, regular, overtime, double-time and time-off hours and pay, additional, misc, compliance and differential pay, breaks, absences and pay period status.
Default grouping: Store > Pay Period > Employee
Can group by: Store, Employee, Pay Period, Shift Date, Business Day
Note: A shift counts in full toward the pay period it starts in.
Schedule Variance
Shows: An audit trail of schedule changes, including what changed, the original and new values, who made the change and when, the hours and cost variance, and any compliance warnings and cost it caused.
Default grouping: Store > Shift
Can group by: Store, Scheduled Shift, Employee
Time Punch Activity Log
Shows: Every time punch and punch edit, including original and adjusted values, punch type and method, who requested and approved it, manager and employee comments, the employee's response, break details and attestations, and the device used.
Default grouping: Store > Employee > Worked Shift
Can group by: Store, Employee, Scheduled Hours, Worked Shift
Filtering
Each column offers filter options that match its type of data:
Column Type | Examples | Filter Options |
Text | Names, comments, warning titles | Contains. Enter several terms to match rows containing any of them. |
Numbers, hours, durations, money | Hours worked, cost | Greater than, less than, equal to, at least or at most. Durations show their unit (hrs, mins, secs). |
Dates | Shift date | From, until or between two dates |
Yes/No | Is a manager, is salaried, is dismissed | Yes, No or Either |
Status | Punch type, employment status, pay period status, severity | Searchable checklist with Select All |
Filters combine, and each one narrows the results further.
The Filters panel lists every active filter. You can add, edit or clear them all from there.
The date calendar starts on your business's configured first day of the week.
Grouping and Totals
Group levels: You can group up to four levels deep.
Employee names: Can be grouped as "First Last" or "Last, First".
Turning grouping on and off: You can switch grouping off without losing the levels you selected.
How totals work:
Hours, pay, cost and counts are added up for each group.
Rates such as Attendance % are recalculated for the group, not averaged, so they stay accurate.
Expand and collapse: You can expand or collapse each group on its own, or all groups at once.
Sorting within groups: Use the Sort & Group panel to control how rows are sorted inside each group.
Display and Formatting
Values follow your business's settings for money rounding, date format and 12- or 24-hour time.
In most views, statuses appear as coloured labels.
The Columns panel includes a search box for finding a column quickly.
Saved Layouts and Tabs
What | How long it's saved |
Column choice, order, widths and pinning | Saved in your browser for next time |
Filters, grouping, sorting and dates | Only while the view's tab is open |
Open tabs | Current session only |
Layouts are saved per browser, not per user account, so they don't carry over to another computer or a private/incognito window.
You can open the same view in several tabs, each with a different layout.
Sharing Views
A shared link opens the view with your filters, grouping, columns, sorting, date range and store selection applied.
The recipient can adjust individual column filters, but your layout, date range and stores are locked.
Opening a shared link never overwrites the recipient's own saved layout, and closing the tab returns them to it.
If the recipient doesn't have permission for the view, they see a "You don't have permission" message.
CSV Export
Contents:
Grouped columns come first, followed by visible columns in the order shown.
Exports include individual rows only. Group rows, subtotals and grand totals aren't included.
Header: The file starts with header lines showing the view name and the selected date range.
Dates and times: Shown in each store's own time zone, using your business's date and time format.
Row limit: Up to 10,000 rows. If your view has more, only the first 10,000 are exported and no warning appears.
Delivery: The file downloads straight to your browser. CSV is the only format available, and exports can't be scheduled or emailed.
Date range: An export can cover up to 15 months.
Data Access
Each view only shows stores you can access at that view's permission level, and only within your own business.
The store picker only lists stores you have access to, and filters can't expand your results beyond that access.
Click-through links to the Schedule or Timekeeping screens only appear where you're allowed to open that screen for that store. The destination screen's own access rules still apply.
Performance
Rows load in pages as you scroll.
Very large queries can take a few seconds to show the first rows.
Features in these release notes may not apply to all clients. Availability depends on your product version, subscription plan, and system configuration. Contact support for details.





