Key Stage 2 and Key Stage 4 data was updated on 4th of July with data for 2022 and 2023.
Deprivation
Fuel Poverty data was updated on 5th of July with data for 2022 and 2021.
Health
The Public Health Outcomes Framework was updated on 27th of July. As part of this update some indicators were deprecated and replaced by new indicators. All deprecated/superseded indicators can be found in our list of deprecated indicators.
Economy & Employment
Universal Creditdata was updated on 25th of July with an update for June 2024 and revised data for May 2024.
Claimant Countdata was updated on 22th of July with an update for June 2024 and revised data for May 2024.
Population
Small Area Population Estimateswere updated on 20th July with data for 2023.
We are pleased to announce that we are currently in the process of updating the National Data Service to use the 2024 Ward boundaries. We are aiming to go live with this change over the weekend of the 5th & 6th October 2024.
Below a few questions and answers around this update.
1. Will the 2024 Ward boundaries replace the existing ward layer in the National Data Service?
Yes, the 2024 ward boundaries will become our standard ward geography. We will not retain the older ward layer. If you have another vintage of wards as a custom geography, this will remain. If you would like us to remove the custom ward layer, please get in touch with our Technical Support team.
Most datasets will be aggregable from LSOA 2011, LSOA 2021 or OA 2021 layers. Where the smallest published level is the older ward layer, there will be some gaps in the data where it does not exist for 2024 wards and cannot be aggregated. This will not affect the majority of datasets.
2. What data will be available for the new ward layer?
When the source data is updated in its normal cycle for 2024 wards, we will include the source data in the service. Where data is available at LSOA 2011, LSOA 2021 or OA 2021, and can be aggregated or calculated, we will aim provide this for the 2024 wards.
3. Will Census 2021 data be available for the new ward boundaries?
We understand that there are no plans from the ONS to republish the Census 2021 data for the newer wards. We will, therefore, fill in the gaps where possible (see answer question 2 for more detail)
4. Will the historic time series of datasets be retained?
Yes, we will try and retain historic time series where possible (see answer to question 2 for more detail).
5. What methodology are you using for the update?
We use the same approach as the ONS. In summary, this means we use the ONS population weighted centroids. Each of them falls into one Ward and the entire value of the source area will be assigned to that Ward.
6. When can we expect the next update of the ward boundaries?
The aim moving forwards is to update the ward boundaries for all customers in the July/August of each year.
Early Years data was updated on 28th April with 2022/2023 data. We have also provided additional indicators for 2021/2022 and 2022/2023.
Please note that as part of wider reforms to the EYFS, the EYFS profile was revised significantly in September 2021. It is therefore not possible to directly compare 2021/22 assessment outcomes with earlier years. As a result we deprecated several indicators as they have been superseded by new indicators from the revised EYFS profile.
Crime data was updated on 20th of April with data for Feb 2024.
Economy & Employment
Universal Credit data was updated on 19th of April (with an update for Feb 2024 and data for Mar 2024).
Claimant Count data was updated on 18th of April (with an update for Feb 2024 and data for Mar 2024).
Annual Population Survey data was updated on 28th of April with data up to Jan-Dec 2023.
Environment
Emissions dataset: scale factor error in emissions per km² and emissions per persons indicators fixed on 28th April. These indicators are now showing as tonnes per km² and tonnes per person respectively.
Population
Small Area Population Estimates was updated on 3rd May with data for 2021 and 2022.
Key Stage 2 data was updated on 1st March with data now available up to 2023.
Crime
Crime data (Dec 2023) was updated on 13th of February.
Economy & Employment
Universal Credit data was updated on 7th of February (with an update for Nov 2023 and data for Dec 2023) and again on 19th of February (with an update for Dec 2023 and data for Jan 2024). Metadata information was improved on 7th of February.
Claimant Count data was updated on 14th of February (with an update for Dec 2023 and data for Jan 2024).
Business Counts were updated on 1st of March with data for 2023.
Deprivation
Metadata for the Low Income Families dataset was improved on 7th of February.
Population
Population Estimates for Regions were republished on 7th of February. We noticed that some duplicates had appeared in the data, confusing the region values within the system so we have refreshed these with the correct values.
This update covers December 2023 and January 2024.
Children & Young People
Free School Meal data detailing pupil eligibility over a prior 6 year period was added on 2nd January. Data has been added from the 2015/16 school year through to 2022/23.
Crime
Crime data (Nov 2023) was updated on 5thof January.
Economy & Employment
Universal Credit data was updated on 19th of December (with an update for Sep 2023 and data for Oct and Nov 2023).
Claimant Count data was updated on 19th of December (with an update for Sep 2023 and data for Oct and Nov 2023) and again on 16th January (with an update for Nov 2023 and data for Dec 2023).
Apprenticeships data was updated on 12th of January to include data for 2021-2022 and 2022-2023. We also fixed the data for the Country geography for 2020-2021.
Environment
The Renewables dataset (2022) was updated on 2nd of January.
The Emissions dataset (2021) was updated on 12th January. On 24th of January we released a fix for missing County level values.
As part of this update we deprecated some indicators of the emission dataset. All deprecated indicators can be found in our list of deprecated indicators.
Health
The Wellbeing dataset (2022-2023) was updated on 3rdof January.
Population
Population Estimates for 2022 were added on 15th of January for Local Authorities and higher level geographies. We also updated all population estimates indicators of these geographies with rebased figures back to 2012. As the changes to historic values are small, we made the decision to not recalculate Claimant Count rates, Universal Credit rates and Crime rates for the years 2012 to 2021.
In version 2.4.0 of Report Builder we have continued to improve the behaviour of the chart widgets, following an upgrade of the charting library in the 2.3.0 update. We have also made changes to how Report Builder works with ArcGIS Enterprise as the data, storage and authentication platform instead of ArcGIS Online.
New features
Ability to add fixed lines and zones to bar and line charts
Bar and Line charts can now show fixed lines or zones additionally to the displayed indicator(s). You can add up to 4 lines and up to 4 zones to the chart. Each line has it’s own fixed value, label, colour, width and style. For each zone, the start and end value, label, colour and opacity can be defined. Lines and zones can be added to either the x or the y axis allowing for a wide rage of use cases.
Ability to add Mean and/or Median lines to bar charts
You can chose to display the mean and/or median line either superimposed over or behind the bars of your bar chart. The label, line style and colour can be adjusted.
Export/print options for web map widgets
The simple version of exporting a web map widget is by enabling the Export Snapshot Button which will appear at the bottom right of the map. It takes a simple screenshot of the map widget and saves it to your browser’s downloads folder.
The more advanced Print Button allows the user to print the web map into different file formats, providing a range of options for size and layout.
Both these export options are mutually exclusive, meaning the Export Snapshot Button will only show if the Print Button setting is toggled off. Please note that the Print Button is not available for 3D maps.
Improved support for using data in ArcGIS Enterprise
Report Builder already supported the use of ArcGIS Server services where these services have been referenced in ArcGIS Online to make them easier to access and discover. In this update however, we have taken further steps to make it possible to use ArcGIS Enterprise as the data, storage and authentication platform instead of ArcGIS Online.
If you are hosting your own data catalog, and this is the data source for a report, the catalog table (master table) can include URLs to services from ArcGIS Enterprise and Report Builder will request and handle the authentication to these services appropriately. If the items are (semi)private you will be prompted to sign in to see the data in the report, whether you are editing the report or viewing it as an end user. An example of this is shown below.
Failure to sign in as a user with sufficient privileges will mean that any widgets in the report containing private data will not load.
Currently, the data catalog master table itself must be hosted in ArcGIS Online, but this is a step towards alternative deployments where the data catalog as well as the data services are hosted in ArcGIS Enterprise.
If you are interested in using Report Builder with data hosted in ArcGIS Enterprise we would like to know, so please get in touch with your Esri UK account manager.
Series Type of Pie Charts simplified
The setting Series Type for Pie Charts has been removed as it caused confusion. The rules now are:
include all areas = true => one “pie” per indicator and each segment corresponds to a feature
include all areas = false => one “pie” per feature (i.e. if you use show comparisons = true) and each segment corresponds to an indicator
Further enhancements
You can now use the Configure App button within ArcGIS Online to open the edit version of the report.
There is now an option to open the metadata pop-up when selecting indicators for text widgets.
It is now possible to configure if comparison bars are displayed at the right of all other bars or included in the core feature bar sorting.
Key bug fixes
Bar charts showing counts per value for a lower level comparison geography (for example the deprivation charts in our standard National Data Service reports) no longer show the x-axis labels in random order.
Bar charts showing one indicator for all areas can again display comparison values as horizontal lines.
It is again possible to create a pie chart showing only one percentage indicator value and filling the remaining pie to 100%.
Metadata pop-ups in the data selection dialogs as well as in the table now hide empty fields.
Time Series Table: Metadata icons are no longer hidden when group-rows-by-indicator is active.
Charts are no longer cut off at the bottom if Title Position is set to title-bar.
Width and Height settings of widgets are now rounded to full numbers when resizing the widget by dragging the handlers.
All infographic widgets now have setting to enable and disable comparison features.
Indicator search option within the widget’s Data & Settings dialog is working reliably even for indicators with special characters or multiple whitespaces in the indicator name.
We hope you will enjoy this new release of Report Builder!
