Data layers & Intelligence
Before you start
These choices need a data layer switched on for your workspace (see Turn on a data layer) with at least one field whose past is kept, and a role that can see that layer. For some layers that history begins only recently and grows over time.
You need a dashboard with chart widgets on it: see Use the chart widgets: Portfolio, Intel and Comparison and Customise your Home dashboard.
Note
Open a dashboard with Headline figures, Breakdown, Cross-tab or the Map on it. Each shows today’s figures until you choose otherwise.

Click the gear icon on the card. Under When, open As at and choose A day in the past.
When appears in these four widgets when the widget’s data layer has a field whose past is kept.

Type a day into Day, or pick one from the calendar. The line under the field says how far back you can go: from where the history begins up to yesterday.
Click Apply.

The card says As at and the day under its title, and every figure is as it stood then. Here 75% of the premises were rated Good or Outstanding on that day, against 58.3% today.

A saved report is re-run every time the data is updated, so it cannot keep a chart that reads the past. The Save as a report icon beside the title is greyed out, and pointing at it says why.
To save the chart as a report, set As at back to Today and remove any conditions over the past.

Open the settings again and turn on Then and now: compare that day with today. Click Apply.
Then and now cannot be used while Show is set to Comparison: choose Portfolio or Intel first.

Each tile leads with today’s figure. The day’s figure sits beneath it, with the difference: here the share rated Good or Outstanding fell by 16.7 points. A count that did not move reads No difference.

A condition over the past counts only the records whose value moved in a window. In the widget’s settings, scroll to the conditions and click Add a condition over the past.
Choose the Field. The list holds only the fields whose past is kept.

Open What and choose:
Each field offers only the choices that make sense for it.

Open Window and choose:
Click Apply.

The condition is written out under the card’s title, here Overall rating declined in the last 12 months, and the figures count only the records that meet it. As with a past day, Save as a report is greyed out.
Note

Open the dashboard you want it on and click Edit layout, then Add widget. Scroll down to Intelligence and click Add beside Trend.
Build a chart, at the top of Add a widget, adds a Trend too, under Line chart: see Build a chart widget. This guide adds the ready-made widget.
The new card says Nothing chosen yet until you open its settings.

Click the gear icon on the card. Choose the Data layer and the Field. Only the layers and fields measured over time are offered.
A trend covers everything the data layer holds, so it takes no conditions and does not show your own companies on their own.

For a field with set values, such as a rating, choose up to four values under Lines: the share of: each draws its own line. For a number, choose the statistic to draw instead, such as the average.
Under Where, choose everywhere, a region or a local authority. Click Apply, then Done to keep the layout.

The Trend draws a point for each month end, with a key naming each line. The history behind it deepens month by month, so newer layers start with only a few points.
Note

Where a field can be split, a Split by choice appears beside the values. Choose a group, such as Service type, and click Apply.
Split, the Trend draws one value’s share, so you choose one value only.

The card draws a line for each group, the four largest, and the heading names the value and the split.

A Trend card can show a line of text in place of the chart:
A Trend over an area with fewer than 5 records is not drawn either, and says so.

Cannot find what you need? Browse the Help Centre or submit a support ticket.