Skip to main content

How do I create visualisations in Insights on the Assignar dashboard?

A visualisation is the chart that shows a report's results in Insights on the Assignar dashboard: a single number, a bar chart, a pie chart, a line chart or a map.

A visualisation is the chart that shows a report's results in Insights on the Assignar dashboard: a single number, a bar chart, a pie chart, a line chart or a map. You need an Insights Creator Licence to build one in Report Builder.

In Insights, a dimension is a field you group by (such as project or supplier) and a measure is a number you count or add up (such as total orders).

Choose a chart in Insights

To choose a chart for a report in Insights on the Assignar dashboard:

  1. Build and run the report in Insights > Report Builder. See How do I create a report in Insights on the Assignar dashboard?.

  2. In the visualisation area above the results, click the chart type you want.

  3. To change colours or labels, click the gear (edit) icon on the visualisation.

  4. Save the report.

The table below shows which chart suits which question, and what data it needs.

Chart

Use it to

Data it needs

Single value

Show one key number, such as month-to-date orders

1 measure; use filters for anything else

Bar or column

Compare categories, such as orders per project

1 dimension and 1 measure

Grouped, stacked or stacked percentage bar

Compare categories split by a second field, such as orders per project by supplier

2 dimensions and 1 measure

Pie

Show each part of a whole, such as orders by status

1 dimension and 1 measure

Line

Show a trend over time

1 date dimension and 1 measure; pivot a second field for one line each

Map

Show where things happen

A location field whose name ends in "For Map"

Change colours and axis labels in Insights

To change a chart's colours or axis labels in Insights on the Assignar dashboard, open the chart's edit menu with the gear icon and choose:

  • Series to change the colours.

  • X to rename the horizontal axis.

  • Y to rename the vertical axis.

Show one line per supplier or project in Insights

To show a line for each supplier, project or other value on a line chart in Insights on the Assignar dashboard, add that field to the report and pivot it: next to the field in the field list, click the pivot icon, then click Run. Each value becomes its own coloured line.

Create a map in Insights

To show data on a map in Insights on the Assignar dashboard:

  1. In Report Builder, add a location field whose name ends in "For Map", and a measure to count.

  2. Click Run, then choose the map chart.

  3. Use + and - on the map to zoom.

  4. To change the circles, open the edit menu and choose Points. You can switch circles to icons, or set Radius Units to Pixels so the size shows the volume.

  5. For a heat map, open the edit menu, choose Plot and pick the heat map option.

Related articles

Did this answer your question?