This brand new set of around 140 indicators can be found in the the Population theme, under a Census 2021 subtheme. This dataset combines the first release results for 2021 – available at local authority, region and country level for England and Wales – with the closest equivalent data selected from NOMIS for 2011, 2001 and 1991 to show change over time in the headline data. The population estimates are broken down by sex, broad age group and 5-year age groups.
Note that there may be some differences to the basis on how the values were generated. Note also that this first release data for 2021 gives figures rounded to the nearest 100 – later release will be unrounded and can be expected to show some differences to these figures.
For customers with a managed Data Observatory website, the data are displayed in the following places:
1) Population reports for top and lower tier local authorities (updated 7th July 2022)
2) Population Map Explorer (updated 4th July 2022)
3) Data Explorer (updated 4th July 2022)
We will add further data from Census 2021 to the National Data Service once these have been released. You can read the release plans from ONS for the data here.
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.
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
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!
We have improved the order in which the Data Explorer will display indicators from the National Data Service on initial load and when it is filtered to a theme (with no search term). Prior to this change, indicators in different themes were ending up with an identical score for the purposes of ordering, which resulted in an illogical and confusing list of indicators from different sub-themes. Where an indicator has supporting indicators (e.g. numerator, denominator, confidence intervals), such as much of the health data in the National Data Service, the supporting indicators are now consistently listed immediately below the main indicator to make it easier to read the list. On initial load, the ONS mid-year population estimates appear first, with the total population at the top of the list.
It is now possible to sort the columns ascending/descending in the table view by clicking on a column heading. The sorting state is maintained even if you switch to view data for a different geography.
Mixed data sources
We have made improvements to the way the Data Explorer works with a data catalog that references ArcGIS Enterprise services as well as services in ArcGIS Online, whether these are public or restricted. This is important for customers that host their own data catalog and wish to incorporate data from a mix of sources.
Custom metadata fields
Again, for customers hosting their own data catalog, any custom/extra fields added to the data catalog metadata table will now be displayed in the Data Explorer (in the Metadata view).
There is now a configuration option to hide indicators that do not have an entry in the data catalog metadata table. This can be useful to exclude certain indicators that need to be part of the catalog, but do not need to be listed in the Data Explorer.
Unable to backtrack after insufficient rights to view a restricted indicator
ArcGIS Online token included in Share link when viewing a restricted indicator
We hope you will enjoy the new version of Data Explorer!
February 2022 monthly and 12 monthly rolling average data were uploaded on the 3rd of March.
Economy & Employment
Claimant Count (March 2022) was last updated on the 12th of April.
People in Universal Credit data for March 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 13th of April.
Annual Population Survey – APS – (Jan 2021-Dec 2021) were last updated on the 14th of April.
As a quick reminder, the Annual Population Survey is a residence-based labour market survey encompassing population, economic activity (employment and unemployment), economic inactivity and qualifications. These are broken down where possible by gender, age, ethnicity, industry and occupation. Available at Local Authority level and above. The APS is updated quarterly.
The PHOF latest release was updated on the 9th of April. A comprehensive list of all updates is available here.
ONS house pricing has been updated on the 5th of April.
Minor adjustments have been applied to the GLA population estimates. Adjusted figures were made available from the 7th of April. GLA Demography produces a variety of different types of population projections for London area in order to meet the needs of a wide range of users.
January 2022 data was not published during the course of February 2022.
Economy & Employment
Claimant Count (January 2022) was last updated on the 16th of February.
People in Universal Credit data for January 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 17th of February.
Key Stage 4 Results for the academic year 20120/21 were released. This release has kept as the measure in relation to the COVID-19 pandemic as a separate dataset. For 2020/21, pupils were only assessed on the content they had been taught for each course. Schools were given flexibility to decide how to assess their pupils’ performance, for example, through mock exams, class tests, and non-exam assessment already completed. GCSE grades were then determined by teachers based on the range of evidence available and they are referred to as teacher-assessed grades, or TAGs. This is a different process to that of 2019/20 when pupils were awarded either a centre assessment grade (known as CAGs, based on what the school or college believed the pupil would most likely have achieved had exams gone ahead) or their calculated grade using a model developed by Ofqual – whichever was the higher of the two.
The changes to the way GCSE grades have been awarded over the last two years (with CAGs and TAGs replacing exams) mean 2020/21 pupil attainment data should not be directly compared to pupil attainment data from previous years for the purposes of measuring year on year changes in pupil performance.
For additional information, please consult the website: