April 2022 monthly and 12 monthly rolling average data were uploaded.
Claimant Count (May 2022) was updated.
People in Universal Credit (May 2022) was updated.
The Fuel Poverty dataset was updated on the 9th of June.
The Electricity and Gas consumption dataset was updated 9th of June.
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.
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.
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.
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.
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.
The setting Series Type for Pie Charts has been removed as it caused confusion. The rules now are:
We hope you will enjoy this new release of Report Builder!
If you have any questions relating to this release please contact Esri UK Technical Support. Customers outside of the UK and Ireland please email support@instantatlas.com.
March 2022 monthly and 12 monthly rolling average data were uploaded on the 12th of April.
Claimant Count (April2022) was last updated on the 17th of May.
People in Universal Credit data for April 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 19th of May.
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.
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.
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.
We hope you will enjoy the new version of Data Explorer!
If you have any questions relating to this release please contact support@instantatlas.com.
February 2022 monthly and 12 monthly rolling average data were uploaded on the 3rd of March.
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.
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 monthly and 12 monthly rolling average data were uploaded on the 10th of March. February 2022 data has been updated in the first days of April.
Claimant Count (February 2022) was last updated on the 22nd of March.
People in Universal Credit data for February 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 18th of March.
January 2022 data was not published during the course of February 2022.
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:
https://explore-education-statistics.service.gov.uk/find-statistics/key-stage-4-performance-revised/2020-21
The main goal of Report Builder version 2.3.0 is the upgrade to the charting library (used for the chart widgets) to the latest available version. This is largely a behind-the-scenes change, although you may notice some very subtle differences to the look and feel of the charts. Besides improving performance and adding functionality, this enabled a number of chart-related feature requests and bug fixes. Version 2.3.0 also includes several non-chart related improvements and bug fixes, as well as changes to support new behaviour in the latest update to ArcGIS Online.
We have introduced two advanced settings to cartesian charts called X Axis – Show Border? and Y Axis – Show Border? which allows for a chart like this (no Y-axis line):
Values for comparison areas are now always displayed to the right of any bar for core layer feature(s) and are not included in the sorting of the other bars.
You can now use the #TODAY variable in a Text or Text Box widget to display indicator values for the current year. This is useful for indicators where the latest date might be different from the current date e.g. population projections.
The #TODAY variable picks up todays’ date and returns it using the specified format:
#TODAY{yyyy} = '2022'
#TODAY{mm} = '03'
#TODAY{mmm} = 'Mar'
As this is the 1st variable to be processed you can use inside the #IVALUE variable using this syntax:
#IVALUE{<id>,1,#TODAY{yyyy}}
Here is an example:
#INAME{catalog:I25097}, #TODAY{yyyy} = #IVALUE{catalog:I25097, 1, #TODAY{yyyy}}
This would result in the following text:
2018-based projected population, persons aged 0-4, 2022 = 13,314
Further information can be found in the Variables help page.
A tooltip has been added to the export icons of charts and tables.
You can use \n to add a line break into a chart tooltip. This is especially useful for smaller chart widgets where the tooltip would otherwise be cut off.
By default, double-clicking on a widget in a report will open the Data & Settings dialog, or in the case of a Text or Text Box Widget, the text editor. While double-clicking on a Text or Text Box Widget, it is possible to accidentally click the Cut button in the widget toolbar and remove the widget from the report, particularly if the text widget only contains one line of text. If you are finding this a problem, you can disable the double-click action for widgets. You can do this by clicking the ellipsis in the top right corner of Report Builder and toggling the Double-click to Edit setting.
The update to the latest charting library meant that we had to make minor changes to the layout and position of Pie Chart legends. If you are using Pie Charts in your reports, especially if these are smaller widgets, you should check that all legend categories are still visible. If not, please adjust the size of the widget slightly until the full legend is displayed.
We hope you will enjoy this new release of Report Builder!
If you have any questions relating to this release please contact support@instantatlas.com.
December 2021 monthly and 12 monthly rolling average data was updated on the 31st of January.
Claimant Count (December 2021) was last updated on the 18th of January.
People in Universal Credit data for December 2021 is now available on the Data Catalog. The latest release was published on AGOL on the 20th of January.
The Annual Population Survey (APS) for Oct 2020 – Sep 2021 was published on the 20th of January. The APS is a residence-based labour market survey that collects information on 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, this dataset is updated quarterly.
The Business Demographics Data for 2020 was published on the 10th of January.
Updated data on Journey Times to key services were published on 10th of January.
November 2021 monthly and 12 monthly rolling average data was updated at the beginning of January due to the Christmas Break.
Claimant Count (November 2021) was last updated on the 14th of December.
People in Universal Credit data for November 2021 is now available on the Data Catalog. The latest release was published on AGOL on the 15th of December.
Indicators from the Public Health API website have been updated on the 24th of December. This updated over 1500 different measures, including numerators, denominators and confidence intervals.
Please find an extract of profiles and measure updated in December below:
Three of these HIV indicators are new:
A subset of indicators concerning the Reproductive Health and Teenage Pregnancy domains have been also updated with the most recent data.
All 14 STI indicators relating to GUMCAD and CTAD data have been updated to include 2020 data. Two of these STI indicators have been modified to better reflect the benefit of STI screening at person level:
For more information, please visit the Fingertips website.
