Skip to main content

How do I create merge reports in Insights on the Assignar dashboard?

A merge report in Insights on the Assignar dashboard combines data from two Report Builder tabs into one report, for example scheduled hours from Allocations beside worked hours from Timesheets.

A merge report in Insights on the Assignar dashboard combines data from two Report Builder tabs into one report, for example scheduled hours from Allocations beside worked hours from Timesheets. You need an Insights Creator Licence.

When to use a merge report in Insights

Use a merge report in Insights on the Assignar dashboard when the fields you need are on different Report Builder tabs. A common example compares, for each project, the hours planned, the hours allocated and the hours actually worked: planned and allocated hours come from Allocations, worked hours from Timesheets.

Other common merge reports in Insights:

  • Asset documents with the asset name: the asset ID and name from Assets, and the document name, expiry date, expiry number, alert number and comment from Documents, joined on the asset ID.

  • Docket hours against timesheet hours: worker times from Digital Dockets and worked hours from Timesheets, joined on the order ID.

The two sets of data must share a field to join on, such as the order ID.

Create a merge report in Insights on the Assignar dashboard

To create a merge report in Insights on the Assignar dashboard:

  1. Go to Insights > Report Builder and click the first tab, for example Allocations.

  2. Add the fields you need, including the field you will join on (for example the order ID), and click Run.

  3. Click the gear icon and choose Merge Results.

  4. A second Report Builder opens. Choose the second data source, for example Timesheets.

  5. Add its fields, including the same join field, and click Run, then Save.

  6. On the merge screen, check that the two join fields are matched, then click Run.

  7. Save the merged report to a dashboard. See How do I create a dashboard in Insights on the Assignar dashboard?.

Keep merge reports fast in Insights

A dashboard tile in Insights on the Assignar dashboard can hold many merged queries, but more than 25 slows it down. Merge only what you need, and filter each query by date. See How do I keep Insights reports fast on the Assignar dashboard?.

Related articles

Did this answer your question?