Skip to main content

How do I keep Insights reports fast on the Assignar dashboard?

Insights reports on the Assignar dashboard load faster, and scheduled deliveries arrive on time, when each report asks for only the data it needs.

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:

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?.

Related articles

Did this answer your question?