If an Insights report on the Assignar dashboard is missing a timesheet, hours or other records you expect, it's usually because the data hasn't reached Insights yet, a filter is leaving it out, or the report has hit its row limit. This article goes through each cause and what to do. It also covers saved reports that seem to have disappeared.
Insights data is not live
Most Insights reports on the Assignar dashboard read from a copy of your data that Assignar refreshes on a schedule, not from the live system. These reports show Data Analytics in the Data Source column of Saved Reports. A timesheet you approved, or a form submitted, a moment ago won't appear until the next refresh. Check the report again later before changing anything.
Filters leave records out of Insights reports
Filters are the most common reason a record is missing from an Insights report on the Assignar dashboard. Check each filter at the top of the dashboard or report:
Date range: the record's date must fall inside it.
Status: many timesheet and payroll reports include only some statuses, for example approved timesheets. A timesheet still Submitted may not show.
Workers, projects or orders: make sure the record's worker, project or order is included.
For a scheduled email, the filters are set separately in the delivery's Filters tab, and its time zone starts on UTC, which can shift "yesterday" by a day. See How do I schedule, change or stop an Insights report delivery on the Assignar dashboard?.
The 5,000-row limit in Insights
Insights on the Assignar dashboard stops a query at 5,000 rows. Records beyond that are left out without a warning, so totals come out low. Narrow the report with a shorter date range or another filter, and run it in parts. See How do I keep Insights reports fast on the Assignar dashboard?.
Time recorded on forms instead of timesheets
Insights reports about hours on the Assignar dashboard, such as Resources: Worker Utilization, count time from timesheets. If your workers record time on a form instead, those hours don't appear in timesheet reports. Build a form results report instead: see How do I analyse form results in Insights on the Assignar dashboard?.
Why have my saved reports disappeared from Insights?
These are the common reasons your own reports seem to be missing from Insights > Saved Reports on the Assignar dashboard.
The Item filter is on Dashboards.My Reports starts by showing dashboards only. Change the Item filter to Reports to see saved reports.
You're on the wrong tab. Your own reports are on My Reports, not Prebuilt Reports.
Your licence changed.Personal reports show only to people with an Insights Creator Licence. If you were moved to a Viewer licence, your personal reports no longer appear. Ask an admin to check under Settings > Insights Licensing.
The report was personal to someone else. A colleague's Personal reports are visible only to them. Ask them to save it to the Group folder.
A payroll report is missing. Payroll export reports show only to people with the Manage Payroll access.
If none of these explain it, contact Assignar Support with the report's name and who created it.
Ask Assignar Support about missing Insights data
If a record is still missing from an Insights report on the Assignar dashboard after you've checked the refresh, the filters and the row limit, contact Assignar Support. Include the report name, the filters you used, and one example record that's missing (for example the worker, date and order of a timesheet).
