Insights reports on the Assignar dashboard load faster, and scheduled deliveries arrive on time, when each report asks for only the data it needs. These are the limits and habits that make the most difference.
Filter by date in Insights reports
Always add a date filter to an Insights report on the Assignar dashboard, such as the last 7 days or this month. A report with no date filter reads your whole history, which slows it down for you and for everyone else in your company.
The 5,000-row limit in Insights
Insights on the Assignar dashboard stops a query at 5,000 rows. When a report reaches the limit, rows beyond it are left out without warning, so totals can be wrong. Filter the report (by date, project or worker) so it stays well under 5,000 rows.
Keep columns and tiles to a minimum in Insights
The table below shows the limits and recommended sizes for Insights reports and dashboards on the Assignar dashboard.
Item | Limit | Recommended |
Rows in a query | 5,000 | Filter to well under the limit |
Columns in a report | 200 | 50 or fewer |
Merged queries in one dashboard tile | No fixed limit | 25 or fewer |
Tiles on a dashboard | No fixed limit | About 4; each tile runs its own query |
Dashboard auto-refresh | No more often than every 15 minutes |
Schedule Insights deliveries wisely
Scheduled deliveries from Insights on the Assignar dashboard run the report every time they send. To keep them fast and reliable:
Don't schedule a report to send several times an hour.
Schedule a single report, filtered to its question, rather than a whole dashboard.
Review your schedules every few months and delete the ones nobody reads. See How do I schedule, change or stop an Insights report delivery on the Assignar dashboard?.
Why is my Insights report slow or showing an error?
These are the common reasons an Insights report on the Assignar dashboard is slow or shows an error.
It takes a long time to load or times out: the report has no date filter, too many columns or too many tiles. Apply the tips above.
"You are not authenticated to view this page.": your Insights session has ended. Refresh the page, or log out of the Assignar dashboard and log in again. If it keeps happening at the same time each day, contact Assignar Support.
The page stops responding in the browser: close other tabs, filter the report to a shorter date range and try again. See Which web browsers does the dashboard support, and what should I do if it's slow?.
