IA Data Explorer 2.1.0 – 10 May 2022 Release Notes

List of changes

Ordering of indicators

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.

Table sorting

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).

Hiding indicators

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.

Bug fixes

  • 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!

If you have any questions relating to this release please contact support@instantatlas.com.

IA National Data Service – April 2022 Update

Crime

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.

Health

The PHOF latest release was updated on the 9th of April. A comprehensive list of all updates is available here.

Housing

ONS house pricing has been updated on the 5th of April.

Population

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.

 

IA National Data Service – March 2022 Update

Crime

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.

Economy & Employment

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.

IA National Data Service – February 2022 Update

Crime

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.

Education

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

IA Report Builder 2.3.0 – 4 April 2022 Release Notes

Overview

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.

New features

Ability to remove chart axis lines without removing axis labels

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):

Ability to show comparison bars in bar charts on the far right

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.

Ability to insert the value for the current date and the current date

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.

Export icon tooltips added

A tooltip has been added to the export icons of charts and tables.

Ability to add line breaks to tooltips

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.

Disable widget double-click edit

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.

Changes in Pie Chart legend layout

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.

Key bug fixes

Chart widgets

  • Cartesian charts: axis colour is overwritten by grid line colour
  • Bar charts: bars sit on top of X-axis, causing axis line to only be visible between the bars
  • Pyramid Chart: palette colour is only applied to left side of chart
  • Report Builder crashes if you set a pyramid chart to Constrain Palette Colours = True and have only one colour defined in the Palette
  • Population pyramid with aggregated data – data label left/right settings get overridden
  • Scatterplot widget: default point size is too small

Text / Text Box Widgets

  • When highlighting the default text to delete it, the text editor closes if the mouse pointer is moved outside of text box
  • Inserting an icon doesn’t allow the icon to be selected (to delete it or change size or colour) and doesn’t allow for text to be added after the icon
  • Text not showing in Edit Text/Rules popup (the first time you edit it)

Other bug fixes

  • Report Builder doesn’t support nested/grouped layers in web maps built with the new ArcGIS Online map viewer
  • First page is blank if you print a report using Firefox
  • Groups on Report Builder home page are not displayed in alphabetical order
  • Time Series Table: table breaks if the indicators have different dates available
  • Long delay for a table widget to show when added to a report
  • “Save As” on existing report creates an AGOL item with an incorrect URL
  • Page order dialog crashes when report contains a large number of web map widgets

 

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.

IA National Data Service – January 2022 Update

Crime

December 2021 monthly and 12 monthly rolling average data was updated on the 31st of January.

Economy & Employment

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.

Environment

Updated data on Journey Times to key services were published on 10th of January.

IA National Data Service – December 2021 Data Update

Crime

November 2021 monthly and 12 monthly rolling average data was updated at the beginning of January due to the Christmas Break.

Economy & Employment

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.

Health

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:

    • Child and Maternal Healthcare: multiples measures about early years, mortality, pregnancy and birth and school-age at different levels.
    • Cancer Services: From 2020/21, the bowel screening indicators have been extracted using a different methodology from previous data.
    • Sexual and Reproductive Health: All 17 HIV indicators have been updated to include 2020 data and revision of previously published data to reflect clinic or laboratory resubmissions and improvements to data cleaning. Therefore, data may differ from previous publications.

Three of these HIV indicators are new:

      • HIV diagnosed prevalence rate per 1,000 population aged 15 years and over
      • New HIV diagnoses among persons first diagnosed in the UK rate per 100,000 aged 15 years and over
      • Antiretroviral therapy (ART) coverage in adults accessing HIV care (%)

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:

      • STI testing positivity (excluding chlamydia aged <25) %
      • STI testing rate (excluding chlamydia aged <25) / 100,000

For more information, please visit the Fingertips website.

IA National Data Service – November 2021 Data Update

Crime

October 2021 monthly and 12 monthly rolling average data was updated and published on AGOL with relative reports on the 29th of November.

Economy & Employment

Claimant Count (October 2021) was last updated on the 16th of November.

The Business Register and Employment Survey (BRES) is a collection of employee and employment estimates at detailed geographical and industrial levels. The provisional 2020 and revised 2019 estimates were released on the 9th of November and published to AGOL on the 11th of the month.

People in Universal Credit data for October 2021 is now available on the Data Catalog. The latest release was published on AGOL on the 17th of November.

Environment

The Environment theme got some brand new additions this last month! Besides updating the Carbon Emissions statistics (2019) on the 4th of November, the NDS now includes two brand new collections about renewable energy and waste management. The Renewables dataset includes information on capacity, generation, and the number of sites for different technologies based on renewable sources. These were published on the 4th of November. The Waste dataset includes information relative to waste collection and management by local authorities, this was uploaded on the 4th of November.

Health

Indicators from the ASCOF – Adult Social Care Framework Outcomes – were updated on the 15th of November. This dataset includes 107 indicators measuring how well care and support services achieve the outcomes that matter most to people. This collection of measures includes indicators coming from multiple sources:

    • Adult Social Care Survey (ASCS). Please note: the 2020-21 dataset was voluntary due to the COVID-19 pandemic. As only 18 CASSRs participated in the 2020-21 survey, aggregated ASCOF outcomes have not been calculated at regional, council type, and England level. Further details are available in the ASCS publication;
    • Short and Long Term Support (SALT);
    • Mental Health Services Data Set (MHSDS);
    • Delayed Transfer of care (DToC) – Due to the impact of coronavirus (COVID-19), the DToC collection has been paused for 2020-21;
    • Survey of Adult Carers in England (SACE). Due to the additional pressures that COVID-19 has brought on all services, the Survey of Adult Carers in England (SACE) 2020-21 was postponed by one full year. It will continue to run biennially and will be included in the 2021-22 ASCOF publication.

Wellbeing indicators (2021) have been updated on the 23rd of November.

Housing

ONS house pricing has been updated on the 24th of November. The latest release includes data for the financial year 2020/2021.

Population

Nationality & Country of Birth data was updated on the 25th of November.

IA National Data Service – October 2021 Data Update

Crime

September 2021 monthly and 12 monthly rolling average data was released at the beginning of October and updated and published on AGOL with relative reports on the 01st of October.

Economy & Employment

Claimant Count (September 2021) was last updated on the 12th of October. All affected reports were published by the 13th of October.

The Annual Population Survey (APS) for Jul 2020 – Jun 2021 was published on the 13th of October. 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.

Topics covered in the APS dataset include:

    • Country of birth
    • Disability level
    • Economic activity (employment, unemployment and economic activity)
    • Ethnic group
    • Health problems
    • Hours worked weekly
    • Industry of employment
    • Job-related training
    • National identity and Welsh language
    • Nationality
    • Occupation of employment
    • Public and private sector employment
    • Qualifications

ASHE – Annual Survey of Hours and Earnings – Indicators (2020) were published on AGOL on the 28th of October. This dataset includes information on weekly and annual pay for full and part-time workers. Disaggregation available by gender.

People in Universal Credit data up till September 2021 is now available on the Data Catalog. Latest release was published on AGOL on the 25th of October.

Experimental Small Area Income Estimates have been published on the 15th of October. These indicators give an experimental measure of gross and net income using data from HM Revenue and Customs’ (HMRC) Pay As You Earn (PAYE), Self-Assessment and the Department for Work and Pensions’ (DWP) benefit systems.

Business Counts (2021) were updated on the 6th of October.

Housing

Council Tax Bands and affected reports have been updated on the 6th of October. Dwelling Types have been published on the 15th of October.

Public Health Outcomes Framework:

The PHOF latest release was updated on the 18th of October. A comprehensive list of all updates is available here.

IA Report Builder 2.2.0 – 15 October 2021 Release Notes

Overview

Report Builder version 2.2.0 fixes a number of bugs and also introduces functionality (beta) to import or link to other reports.

Bug fixes

  • Case sensitivity issue with feature ID field
  • Stacked bar chart with look-down comparison areas shhowing incorrect colours
  • Web map widget – visible layers not acting on raster layers
  • Text widget stripping text following a number (improvement to number formatting)
  • Editing table widget indicator aliases breaks widget height
  • Icon Chart widget height behaviour
  • “Fill to” settings missing from Icon Chart widget
  • Toggler widget not working on a phone screen
  • Report toolbar display issues on a phone screen
  • Commas missing between list of area names (#FNAMES) for aggregated reports

Importing/linking to other reports

It is now possible, for any page in a report, to specify another Report Builder report to import or to link to. This means that one report can be built from others, and that if linking is used, that any changes made to linked reports will automatically feed through to the parent report. This opens the door for a different approach to building and managing reports.

Note that this is beta functionality and we welcome any feedback on how we have implemented this in Report Builder. We created a help page and will be adding further information and examples to this.

To access the option to import or link, edit your report and click Pages > Current Page > Import or Link.

Report Builder option to import or link a report

You will be asked for browse in your ArcGIS Online organisation for a report design to import/link.

Report Builder choose report design option

We hope you will enjoy using this new functionality!

If you have any questions relating to this release please contact support@instantatlas.com.