Data layers & Intelligence

Add the Spread and Compare widgets to a dashboard

6 min read
Spread shows how one field of a data layer spreads across a region or local authority. Compare puts the companies your workspace holds beside that area, on one scale. Here you add both to a dashboard, read their figures, and share them correctly. It takes about five minutes.

Before you start

These widgets need a data layer switched on for your workspace (see Turn on a data layer), and a role that can see that layer.

Note

The figures, field values and licence lines in these pictures are examples made up for this guide. They are not real statistics. The fields and areas you can choose depend on the data layers your workspace has switched on.

Create a dashboard

In Views, click the + at the end of the tab strip and choose New view. Choose Start blank, then Dashboard, then Next.

Give the dashboard a name and click Next. On the Widgets step, untick any widgets you do not want, then click Create.

The Create view dialog on its Kind step, with Dashboard selected among List, Pipeline, Dashboard, Report and Intel View, and a Next button.

Open Edit layout

Click Edit layout, then Add widget. If you already have a dashboard of your own, you can open that instead and start here.

A new dashboard tab called North West market, showing No widgets yet with an Add widgets button, and an Edit layout button at the top right.

Add the Spread widget

Build a chart sits at the top of Add a widget, for making a chart of your own (see Build a chart widget). This guide adds ready-made widgets.

Scroll down to the Intelligence group under Ready-made and click Add beside Spread.

The Intelligence group in the Add a widget dialog, listing Intel View, Your companies, Spread, Compare, Headline figures, Breakdown, Cross-tab, Map, Trend and What moved, each with an Add button. Spread reads How a field from a data layer spreads across a region, local authority or integrated care board: bars, a donut or a segmented bar.

Open the widget's settings

The widget says Nothing chosen yet. Click the gear icon in the strip above it.

The dashboard in Edit layout with one Spread widget labelled In Beta, saying Nothing chosen yet and Choose a field and an area in this widget’s settings. The strip above the widget, headed Spread, has width, height, gear and remove icons, and the page has Add widget (1/24), Cancel and Done buttons.

Choose the data layer, field and area

Fill in the settings, then click Apply:

  • Data layer: one of the layers switched on for your workspace.
  • Field: what to count. You are offered fields that fall into groups, such as a choice, a yes or no, or a list.
  • Draw as: how the figures are drawn, such as Bars.
  • Area type: Region or Local authority.
  • Area: the region or local authority itself.

Name and Conditions are optional: leave the name blank to keep the widget’s own title, and with no conditions everything is counted.

The Spread settings dialog: an empty Name field; under What to show, Data layer set to Companies House, Field to Company status and Draw as to Bars; under Where, Area type set to Region and Area to North West; under Conditions, the line No conditions: everything is counted and Add criterion; and Cancel and Apply buttons.

Add Compare, then save

Click Add widget again and click Add beside Compare. Open its gear icon, choose the same four settings, and click Apply.

Click Done to save the layout. Nothing is saved until you do. Each card is titled with its field, such as Spread: Company status.

The saved dashboard with a Spread widget titled Spread: Company status and a Compare widget titled Compare: Company status side by side, each title on two lines and each card labelled In Beta, with Export PDF and Edit layout buttons above them.

Read the Spread figures

Percentages are of those with a value, and the line at the top says how many that is. Here, has a value for 7 of 8 organisations means the area has 8 records and 7 of them have a value for this field. So 57.1% (4) is 4 of those 7, not 4 of the 8.

The number in brackets is the count. The Sources line under the figures names where they come from and ends with the date they are as at.

A Spread widget titled Spread: Company status. Under the line North West: Company status has a value for 7 of 8 organisations are example bars for Active at 57.1% (4), In liquidation at 28.6% (2) and Dissolved at 14.3% (1), then a Sources line naming Companies House and the Office for National Statistics, as at 22 Oct 2026, with an info button.

Open the licence lines

Click the info button at the end of the Sources line. The card opens out under it to list every line the data’s licences ask for, word for word: each source’s attribution, any notice, and how current the data is. Click the button again, or press Esc, to fold them away.

The Spread widget with its licence lines folded out inside the card, indented under the Sources line: Example licence line for this data layer, Example licence line for the area data, Example notice to be shown with these figures and Example note on how current this data layer is.

Read the Compare figures

Each value has two bars: your companies, then the area. Both use the same 0 to 100% scale, so you compare shares rather than counts. Each has its own line saying how many have a value.

Your companies means the companies linked to register records and held at Atlas, the service that supplies your data layers. It does not mean every company in your CRM, and it is not limited to the area you chose. A company with no linked record is not counted.

A Compare widget titled Compare: Company status. The lines at the top read Your companies: Company status has a value for 5 of 6 organisations and North West: Company status has a value for 7 of 8 organisations. A key shows Your companies in teal and North West in gold, and each status has two example bars side by side on a 0% to 100% scale in 20% steps, such as Active at 60% (3) and 57.1% (4). A Sources line with its as-at date is at the foot.

Understand a small group

When a group has fewer than 5 records, the widget gives the number found and says Figures are not shown for fewer than 5.

To see figures, try a larger area. In Compare, the rule applies to each side separately, so one side can still show its figures while the key marks the other as fewer than 5.

A Spread widget titled Spread: Company status saying East Midlands: 3 found. Figures are not shown for fewer than 5. No bars are shown, and the Sources line remains.

Understand a total above 100%

Some fields are lists, so one record can hold several values and count under each of them. The percentages can then add up to more than 100%, and the widget says so. This is correct, not an error.

A Spread widget titled Spread: Sector, for an example list field, with bars for Manufacturing at 85.7% (6), Retail at 71.4% (5) and Wholesale at 14.3% (1), and the line One record can count under more than one value, so these can add up to more than 100%.

Give a new workspace's Compare a moment

In a new workspace, Compare can take a moment to fill in, because your linked companies are still reaching Atlas. Until then it shows Your companies: none linked to this data layer yet beside the area’s figures.

The widget checks again by itself for about two minutes, so you can leave the page open. If it still says so, reload the page. It stays that way if no company in your workspace is linked to a register record.

A Compare widget in a new workspace saying Your companies: none linked to this data layer yet. If you have just switched it on, this can take a moment. The key shows Your companies (fewer than 5) greyed out beside North West, and only North West’s example bars are drawn.

Know what In Beta means

Both widgets carry an In Beta label. It marks a new feature whose data may be inconsistent, so check a figure at its source before you rely on it.

The top of a Spread widget titled Spread: Company status, with the In Beta label beside the title, above the line North West: Company status has a value for 7 of 8 organisations.

Export the figures, and keep the licence lines with them

Click Export PDF above the dashboard. The figures print with the In Beta line, the date and every licence line, in full.

If you copy the figures anywhere else, such as a slide or an email, copy the licence lines and the date too. Our Terms ask you to keep the attribution and the date, as OroMiQ shows them, wherever you show or share this data. The Data sources page lists each source and its licence.

Note

Some data layers’ licences allow no copy of this kind. A widget using one of those layers prints a line saying it was left out of the PDF, instead of its figures.
A dashboard PDF titled North West market, prepared by Alex Morgan, with the Spread: Company status and Compare: Company status blocks side by side. Spread has example bars such as 57.1% (4); Compare is a table of Your companies and North West. Under each block are the In Beta line, the As at date and the four example licence lines in full.

If a widget says Not available to you

A dashboard can be shared with team members whose role does not include the chosen data layer. They see Not available to you and no figures, on screen and in the PDF. To change that, ask an admin about your role in Settings > Team & roles.

A Spread widget labelled In Beta, showing only the words Not available to you.