Skip to main content

How do I create a report in Insights on the Assignar dashboard?

To create your own report in Insights on the Assignar dashboard, you pick a data source in Report Builder, choose the fields you want and click Run.

To create your own report in Insights on the Assignar dashboard, you pick a data source in Report Builder, choose the fields you want and click Run. You need an Insights Creator Licence; with a Viewer licence, Report Builder does not appear in the menu.

Report Builder data sources in Insights

Report Builder in Insights on the Assignar dashboard shows a tab for each kind of data. Pick the tab that matches your question; the fields on the left change to match it.

The tabs are: Assets, Allocations, Competencies, Documents, Fieldworkers, Form Results, Inductions, Timesheets, Orders, Costs, Digital Dockets, Order Estimates and Calendar dates. Your company can rename some of these words.

Report on chargeable items and captured dockets in Insights

To report on chargeable items, or on the paper dockets captured with them, in Insights on the Assignar dashboard, use the Costs tab in Report Builder. You need an Insights Creator Licence.

  • The Costs tab has a row for each chargeable item recorded on an order, with its quantity, rate and comments, and the order, task, supplier and asset it was recorded against. It also shows when the item was recorded and changed, and whether it was deleted.

  • The Costs tab also holds timesheet pay items and charge items. Filter on the field that marks a row as a chargeable item to keep only chargeable items.

  • When a worker adds a photo of a paper docket to a chargeable item on the Assignar mobile app, with a docket number and date, that docket is linked to the chargeable item's row. Add the docket fields, such as the docket number and docket date, to see which docket each item came from.

A few companies also see a Chargeable Items for Allocations tab. If you don't have it, use Costs.

Report on digital dockets in Insights

To report on digital dockets (the dockets crews fill in from a template on the Assignar mobile app) in Insights on the Assignar dashboard, use the Digital Dockets tab in Report Builder. It has a row for each answer on each docket, with the docket template, client, project, order and the worker who created the docket, plus each question and its answer. For the workers on a docket, it has each worker's shift start, shift end, break time and total time.

To compare docket hours with timesheet hours, for example for one project, build a merge report: the docket times from Digital Dockets and the worked hours from Timesheets, joined on the order ID. See How do I create merge reports in Insights on the Assignar dashboard?.

Report on asset documents and their expiry in Insights

To report on the documents attached to assets, such as a service due by machine hours or kilometres, in Insights on the Assignar dashboard, use the Documents tab in Report Builder. You need an Insights Creator Licence.

The Documents tab has a row for each document attached to an asset, attachment, client, project or supplier. Its fields include the document name, document type and label, expiry date, alert date, expiry number, alert number and comment, and whether the document is active. Filter on the record type (entity) to keep only asset documents.

The Documents tab identifies the asset by its ID, not its name. To show the asset name beside each document, build a merge report: the asset ID and name from the Assets tab, and the document fields from the Documents tab, joined on the asset ID. See How do I create merge reports in Insights on the Assignar dashboard?.

Create a report in Insights on the Assignar dashboard

To create a report in Insights on the Assignar dashboard:

  1. Go to Insights > Report Builder.

  2. Click the tab for the data you want, for example Timesheets.

  3. In the field list on the left, find a field by scrolling or typing in Find a Field, then click it. It is added to the report. Repeat for each field you need.

  4. To narrow the data, add a filter: next to a field, click the filter icon, then set the filter value in the Filters area. A date filter keeps the report fast.

  5. Click Run.

The results appear as a table, with a chart above it. The report shows 500 rows by default; you can raise the row limit to 5,000.

Save a report in Insights on the Assignar dashboard

To save a report you built in Insights on the Assignar dashboard:

  1. Click the gear icon at the top right of Report Builder.

  2. Choose Save, then choose to save it as a report (a "Look") or to a dashboard.

  3. Choose a folder:

    • My folder (Personal): only you can see it.

    • Group: every Insights user in your company can see it.

  4. Enter a name and click Save.

The report then appears on Insights > Saved Reports > My Reports. Saved reports are listed under the Item filter Reports, not Dashboards.

Saving a single report, rather than a whole dashboard, is best when you plan to email it on a schedule, because you can filter it tightly to the question it answers.

Start from a prebuilt report in Insights

To build on a prebuilt report in Insights on the Assignar dashboard instead of starting from nothing, open the prebuilt report, open the menu on the tile you want and choose Explore from here. The tile opens in Report Builder, where you can add fields and save it as your own report.

Why can't I see Report Builder?

Report Builder appears in the Insights menu on the Assignar dashboard only for people with an Insights Creator Licence. If you have a Viewer licence, ask an admin to change you to a Creator licence under Settings > Insights Licensing. See How do I give someone an Insights licence on the Assignar dashboard?.

Get help building a report in Insights

If you're not sure how to build the report you need in Insights on the Assignar dashboard, contact Assignar Support. Say what the report should show (the rows, the columns, the date range and any totals) and attach an example if you have one.

Related articles

Did this answer your question?