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.

IA National Data Service – September 2021 Data Update

Crime

August 2021 monthly and 12 monthly rolling average data was released only at the beginning of October. Data updates will figure in the October blog update.

Economy & Employment

Claimant Count (August 2021) was last updated on the 14th of September. All affected reports were published by the 16th of September.

The Annual Population Survey (APS) for Apr 2020-Mar 2021 was published on the 17th of September. 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.

Population

The Population estimates for small area based by single year of age have been updated on the 16th of September. The latest referral year is 2020.

Education

Data from the 2021 School Census was added to the National Data Service on the 7th of September. This release contains information on pupil characteristics including:

    • Free School Meals (FSM) eligibility
    • English as an additional language
    • Ethnicity
    • Special Educational Needs or Education, Health and Care Plan

IA National Data Service – August 2021 Data Update

Crime

June and July 2021 monthly and 12 monthly rolling average data was released both in July. The latest July data update was published on the 31st of August and related reports were published on the 1st of September.

Economy & Employment

Claimant Count (July 2021) was last updated on the 17th of August. All affected reports were published by the 17th of August.

Deprivation

Fuel Poverty Data for the year 2019/20 was last amended on the 13th of August introducing new Low-Income Low Energy Efficiency (LILEE) metric of fuel poverty that was adopted in the last year of publication.

The sub-regional estimates for 2019 are the first to be published using the LILEE metric. It should be noted these are not directly comparable with previous estimates made for sub-regional fuel poverty under the Low Income High Costs (LIHC) definition. The 2019 LILEE sub-regional fuel poverty model is based on the following seven variables, derived from public and commercial sources:

    • Tenure-owner-occupied, private rented, social rented (Experian)
    • Dwelling age – pre-1919, 1919 to 1944, 1945 to 1980, post-1980 (Experian)
    • Household composition (Experian)
    • Mosaic household classifications by postcode
    • 15 socio-economic groups as detailed in the Mosaic guide4 (Experian)
    • Dwelling type – terraced, detached, semi-detached, bungalow, flat (Experian)
    • Government office region (Experian)
    • Proportion of households with no qualifications per COA (2011 Census)

A household is considered to be fuel poor following the LILEE metric if it is living in a property with an energy efficiency rating of band D, E, F or G as determined by the most up-to-date Fuel Poverty Energy Efficiency Rating (FPEER) Methodology and its disposable income (income after housing costs (AHC) and energy needs) would be below the poverty line.

Please be reminded that fuel poverty is measured based on required energy bills rather than actual spending. This ensures that households that have low energy bills simply because they actively limit their use of energy at home, for example by not heating their home, are not overlooked.

 

IA National Data Service – July 2021 Data Update

Crime

June 2021 monthly and 12 monthly rolling average data was released only at the beginning of July. Data updates will figure in the August blog update.

Economy & Employment

Claimant Count (June 2021) was last updated on the 15th of July. All affected reports were published by the 17th of July.

Gross Value Added (GVA) for the year 2019 was updated on the 6th of July.

In the economic accounts, the economy is split into institutional sectors, that is, units broadly grouped according to their role in the economy. The GVA measures the increase in the value of the economy due to the production of goods and services. It is measured at current basic prices, which include the effect of inflation, excluding taxes (less subsidies) on products. GVA plus taxes (less subsidies) on products is equivalent to Gross Domestic Product (GDP) [Source ONS: UK Regional Accounts Methodology Guide].

Health

Data from the latest PHOF (Public Health Outcome Framework) update, specifically July 2021, was published on the 22nd of July.

This update concerns 4 indicators. In detail:

    • C26a – Cumulative percentage of the eligible population aged 40 to 74 offered an NHS Health Check
    • C26b – Cumulative percentage of the eligible population aged 40 to 74 offered an NHS Health check who received an NHS Health Check
    • C26c – Cumulative percentage of the eligible population aged 40 to 74 who received an NHS Health Check
    • E15 – Estimated dementia diagnosis rate (aged 65 and over)

On the 22nd of July, a new set of indicators was also added to the National Data Service in relation to Child and Maternal Health. This edition includes a series of measures that can be grouped into the following main categories:

    • Breastfeeding
    • Early Years
    • Early Years supplementary indicators
    • Health behaviours in 15 years old
    • Long term conditions and complex health needs
    • Mortality
    • Oral Health
    • Pregnancy and birth
    • School-age Children
    • School-Age Children supplementary indicators
    • Unintentional injuries
    • Vulnerable children and young people
    • Young people supplementary indicators

    IA Report Builder 2.1.0 – 19 July 2021 Release Notes

    Overview

    Report Builder version 2.1.0 introduces a new widget, the Toggle Content widget. This has been added in order to enable content sections in a report to be expanded/collapsed by the end user. Prior to the addition of this widget, the same “accordion” effect had to be achieved using styling in the website that the report was embedded into.

    Toggle Content Widget

    In the example below, the end user can click the button next to the Safeguarding heading to collapse the content below it (this is just an image, the toggle won’t do anything here!).

    InstantAtlas Report Builder Toggle Content Widget

    The different settings available for this widget are described on the widget help page.

    Number Formatting

    It is now possible to specify a percentage number format (P) for your widget to show data as percentages. For example, for a Data Table widget, locate the Number Format setting under Numbers & Values and replace this with P. For a Bar Chart widget, locate the Axis Label Format setting under Axes and type in P. Visit this page for more on the number formats supported in Report Builder.

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

    IA National Data Service – June 2021 Data Update

    Crime

    May 2021 monthly and 12 monthly rolling average data were uploaded on the 30th of June. All affected reports for May 2021 were published by the 05th of July.

    Economy & Employment

    Claimant Count (May 2021) was last updated on the 18th of June. All affected reports were published by the 21st of June.

    Population

    Population estimates for the UK, England, mid-2020 were last updated on the 25th of June. All affected reports were published by the 26th of June.

    Health

    The PHOF (Public Health Outcome Framework) update from May 2021 was published on the 5th of June. Reports were updated on the 27th of June.

    This update concerns 17 indicators. In detail:

      • Overarching Indicators domain: 5 indicators including healthy life expectancy at birth, disability-free life expectancy at birth and inequality in healthy life expectancy for England;
      • Wider determinants of health domain: 1 indicator -: first-time entrants to the youth justice system;
      • Health improvement domain: 5 indicators including the percentage of looked after children whose emotional wellbeing is a cause for concern, proportion of the population meeting the recommended ‘5-a-day’ on a ‘usual day’ (adults) and percentage of physically active adults;
      • Healthcare and premature mortality domain: 5 indicators covering emergency readmissions within 30 days of discharge from hospital and preventable sight loss.
      • Health protection domain: 2 indicators including population vaccination coverage – HPV vaccination coverage for two doses (females 13-14 years old) and population vaccination coverage – Meningococcal ACWY conjugate vaccine (MenACWY) (14-15 years)

    The data for the indicator ‘C27 – Percentage reporting a long term Musculoskeletal (MSK) problem’ has been revised to reflect changes in the GPPS questionnaire, which changed the base population from 18+ to 16+.

    Indicator ‘D04e – Population vaccination coverage – HPV vaccination coverage for one dose (12-13 years old)’ has been split by gender, due to changes in vaccination coverage.

     

    IA Report Builder 2.0.2 – 14 June 2021 Release Notes

    Overview

    Report Builder version 2.0.2 addresses a number of bugs, several of which will  ensure a smoother migration from version 1 to version 2 reports. We have also added some of the functionality of Report Builder 1 that had not yet been implemented in version 2, as well as performance, accessibility and error handling improvements.

    Bug fixes

    • Bar Charts set to horizontal orientation now also work when the selected data contains upper and lower confidence limits.
    • The Scatter/Bubble Chart widget has gained the setting X Axis Range which allows the x-axis to be constrained between two defined values.
    • The Scatter/Bubble Chart widget can now be configured to show all points in the same colour without having to define a separate colour for each feature. This is done by switching Constrain Palette Colors on:
    • The Filled Icon widget now shows the icon filled in the selected Highlight Color if Highlight Selected Feature is enabled.
    • Copying widgets from one report to another now works more reliably. In version 2.0.1 and when copying multiple widgets in succession, a browser refresh was required between pasting different widgets.
    • In the Edit Chart Colors… dialog (main menu – StylingChart Colors) the Toggle direct edit buttons now work by providing a text field to insert colour values in hexadecimal or RBG format.
    • Exiting a report now takes the user back to the same folder view with the same sorting retained.
    • Fix for an issue with hash/anchor links that occurred when using the # symbol in the browser address bar . This allows users e.g. to jump to a particular section of a report by providing the URL to the anchor tag.
    • Fix for certain font families (those containing spaces in the name) not being applied in view mode of a report.

    Improved migration

    • Pie Charts in migrated reports no longer group small segments together into one category.
    • Titles of Table widgets are now migrated correctly.
    • The content of the Table Footer settings from Report Builder 1 is now migrated to the setting Caption in Report Builder 2.
      Please note: Any tables in reports that have been migrated and saved before the release of Report Builder version 2.0.2 will have lost the Table Footer text. You can re-add the text by entering it into the Caption setting manually. Alternatively, if the equivalent version 1 report still exists, you can migrate it again.

    Additional functionality

    • It is now possible to change the font colour of text in a Text widget through the editor toolbar. You have the option to choose one of the predefined colours or use the palette icon to open the Color Picker dialog
    • The Advanced Settings dialog in the Pages menu has gained options to customise the index page of the report.
    • Any changes to the Pages|Advanced Settings dialog now turns the Save button of the report editor orange, indicating that there are unsaved changes.
    • Line and scatterplot widget point styles have been extended and some of the less obvious options have been subtly renamed.
    • Web accessibility has been improved by adding the option to show unique point markers in chart series lines and index options to chart labels – please see this blog post to find out more about accessibility for reports created using Report Builder. 
    • The Data Catalog data model is cached in the browser whilst the editor page is open, which means the widget settings dialog opens faster.
    • Improved error messaging when/if connections fail.
    • Widgets have become more robust to temporary data connection errors. If a connection fails, the widget will attempt to reconnect to the data after a few seconds, up to 3 times before giving up.

    If you have any questions relating to this release or migration of reports from version 1 to version 2 please contact support@instantatlas.com.

    IA National Data Service – May 2021 Data Update

    Crime

    April 2021 monthly and 12 monthly rolling average data were uploaded on the 5th of May. Data relative to May 2021 was published on the 26th of May. All affected reports for May 2021 were published by the 29th of May.

    Economy & Employment

    Claimant Count (Apr 2021) was last updated on the 18th of May. All affected reports were published by the 21st of May.

    Deprivation

    Fuel Poverty Data for the year 2019/20 was last updated on the 15th of May.

    Children in Absolute and Relative Low-Income Families (2019/20) was last updated on the 17th of May.

    IA National Data Service – April 2021 Data Update

    Economy & Employment

    Claimant Count (Mar 2021) and Annual Population Survey – APS – (Jan 2020-Dec 2020) were last updated on the 20th of April. All affected reports were published by the 29th 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.

    Education

    Key Stage 5 Results for the academic year 2019/20 were released. This release has been uploaded as a new dataset in relation to the COVID-19 pandemic. During the pandemic, the exams were cancelled and the results were awarded by a centre assessment grade (based on what the school or college believed the student would most likely have achieved) or their calculated grade using a model developed by Ofqual – whichever was the higher of the two. The statistics have increased as a result of this awarding method – more than would be expected in a typical year – between the 2018/19 and 2019/20 academic years. This reflects the change to the way grades were awarded rather than improvements in pupil performance. As a result, the 2019/20 data should not be directly compared to attainment data from previous years to measure changes in student performance. For these specific reasons, the measures for Key Stage 5 in 2018/19 e the same measures for 2019/20 are now two separate datasets. Furthermore, the department decided to not publish value-added measures, as these measures are calculated by a model that is based on national averages. Considering the awarding method, the estimated model would not measure the progress made by a pupil in a meaningful or accurate manner. However, for consistency and transparency, the remaining headline measures were reported in this statistical release (amongst others):

    • Attainment in terms of Average Point Score (APS) per entry for A level (subset of Academic), Applied General, Tech Level, and Technical Certificate exam cohorts

    • English and maths progress

    For additional information, please consult the website:

    A level and other 16 to 18 results, Academic Year 2019/20 – Explore education statistics – GOV.UK (explore-education-statistics.service.gov.uk)

    IA National Data Service – March 2021 Data Update

    Crime

    February 2021 monthly and 12 monthly rolling average data were uploaded on the 25th of March. All affected reports were last updated on the 26th of March.

    Economy & Employment

    Claimant Count (Feb 2021) was last updated on the 23rd of March. All affected reports were published by the 27th of March.

    Education

    Key Stage 4 Results for the academic year 2019/20 were released. This release has been uploaded as a new dataset in relation to the COVID-19 pandemic. During the pandemic, the exams were cancelled and the results were awarded by a centre assessment grade (based on what the school or college believed the student would most likely have achieved) or their calculated grade using a model developed by Ofqual – whichever was the higher of the two. The attainment statistics have increased as a result of this awarding method – more than would be expected in a typical year – between the 2018/19 and 2019/20 academic years. This reflects the change to the way GCSE grades were awarded rather than improvements in pupil performance. As a result, the 2019/20 data should not be directly compared to attainment data from previous years to measure changes in student performance. For these specific reasons, the measures for Key Stage 4 in 2018/19 e the same measures for 2019/20 are now two separate datasets. Please note that Progress 8 indicators are not available in 2019/20. These measures are calculated by a model that is based on national averages. Considering the awarding method, the estimated model would not measure the progress made by a pupil in a meaningful or accurate manner.

    For additional information, please consult the website:

    Key stage 4 performance, Academic Year 2019/20 – Explore education statistics – GOV.UK (explore-education-statistics.service.gov.uk)