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.
– International and Desktop customers please jump to the bottom of this post –
Support cases must be submitted via My Esri or the over phone and for this you will need to be an Authorised Caller. An Authorised Caller is a designated individual who may contact Esri UK online or by telephone to request Support. Your My Esri Administrator has the ability to manage your organisation’s allocation of Authorised Callers.
Your Authorised Callers must be prepared to provide your Esri customer number and as much information as possible regarding the issue being reported, such as the version of the software and operating system affected, steps to reproduce the problem, and the exact text of any error messages.
The Esri UK Technical Support Team handle cases for many different software products, so please be as specific as you can when raising your question or issue. Please provide links and screenshots where appropriate.
My Esri is a single location online where you can manage all aspects of your relationship with Esri UK. My Esri consolidates your organization’s information into a single experience, including data from Support, Customer Service, Events, and Training. My Esri also contains software downloads and authorisation numbers necessary for you to install and activate Esri products (note: not necessary for InstantAtlas).
You can sign in to My Esri by visiting https://my.esri.com/. You can use your existing Esri Account to sign in. If you do not already have an account, you can create one from the Sign In page in My Esri by clicking on Create a Public Account.
Steps for navigating to the Support page:
Step 1: Click on the tab My Organizations located at the top of My Esri page.
Step 2: Ensure your organization (customer number) in the dropdown menu located in the upper right corner of My Esri page is selected.
Step 3: Click on the subtab Support at the top of My Esri page.
Step 4: Navigate to the various Support pages by clicking on the Support menu items located on the left of My Esri page: Support Overview, Recent Activity, Request Case, Manage System Profiles, Cases, Bugs, Hot Fixes, Authorized Callers.
Please ensure that each issue is logged as a separate case and avoid adding multiple questions together in one case.
Steps for submitting a case:
Step 1: Navigate to the Support page (see My Esri – Signing in and navigating to the Support page).
Step 2: Click Request Case. The steps below apply if the ‘By describing your product’ option is selected.
Step 3: Select ‘More products’ from the Product Category menu.
Step 4: Select ‘Other’ from the Product Sub-Category menu.
Step 5: Select the appropriate Product. The table below provides some examples to guide you.
| Product in My Esri | When to use | Example |
| InstantAtlas Data Observatory
|
A general issue relating to the observatory solution, including the front-end website | Why is the text I have added in WordPress not displayed in the website? |
| National Data Service
|
An issue specifically related to the data in the National Data Service and how this displays in the reports and apps | Why are the latest population estimates not showing for the wards in my area? |
| InstantAtlas Data Explorer
|
An issue specifically relating to the functionality of the Explorer apps embedded in the observatory website | Why am I unable to locate the data I am searching for using the Data Explorer? |
| InstantAtlas Dashboard Builder
|
An issue specifically relating to the use of Dashboard Builder app to create your own dashboards | Why am I unable to connect my CSV data source to my data layer? |
| InstantAtlas Data Catalog
|
An issue specifically relating to any of the tools belonging to the Data Catalog app | Why am I unable to find my hosted catalog in the Data Catalog Manager tool? |
Step 6: Select ‘N/A’ in the Version, Operating System, and Operating System Version menus.
Step 7: Click Next to enter the issues details, then click Next to fill in the addition contact information.
Step 8: On the request summary screen click Send Request.
When submitting new cases to Esri over the phone, your Authorised Callers are prompted to provide the following before being routed to the appropriately-skilled Support analyst:
Authorised Callers are validated for submitting a new case upon providing their customer number. When calling back to discuss an existing case, the caller is prompted for the customer number and case number.
Phone number: +44 (0)1296 745 555
Available Monday to Friday, 9:00 to 17:30 excluding Public Holidays (England)
The only exceptions to the process described above are:
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.
Report Builder version 2.2.0 fixes a number of bugs and also introduces functionality (beta) to import or link 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.
You will be asked for browse in your ArcGIS Online organisation for a report design to import/link.
We hope you will enjoy using this new functionality!
If you have any questions relating to this release please contact support@instantatlas.com.
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.
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!).
The different settings available for this widget are described on the widget help page.
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.
A major new version of InstantAtlas Report Builder (version 2.0) is now available. Report Builder 2.0 is a complete redesign and rebuild of the application, keeping all that was good from version 1 whilst making the reports faster to load, easier to create, more responsive to different devices and more accessible to a range of users.
The process of building a report and editing widgets is essentially the same as in Report Builder 1. It was important to us that that existing users did not have to learn how to create reports all over again! However, there are a few notable differences within the Editor user interface that we thought we would point out to make switching to using Report Builder 2 a little easier.
When you create a new report in 2.0, this will automatically be saved either in the root of your ArcGIS Online account, or if you selected a folder on the Report Builder homepage before creating your report, in that folder. You can always move this to a different folder if you need to using the ‘Move’ option in ArcGIS Online.
We no longer override the browser’s context menu when right-click with your mouse on a report page in the Report Builder workspace. You can access the same functionality in other ways, either from the top menus, or in the case of pasting a widget, using the ‘jigsaw bar’ at the foot of the page or by selecting an existing widget on the page and clicking the page button that appears in the widget toolbar.
This is now done from the Settings tab of the widget Data & Settings window – in Report Builder 1 it was done under the Data tab.
This is now done from the Settings tab of the widget Data & Settings window (usually in the Behaviour settings group which becomes visible when the advanced settings are toggled on) – in Report Builder 1 it was done under the Data tab.
This was an option in Report Builder 1 option but has been dropped. It is unnecessary due to the way the reports load in Report Builder 2. It is entirely possible to use reports ‘live’ so that they always show the latest data in the report data source(s), and so that you do not have to publish them as static files each time the source data is updated.
By default, reports now show a toolbar at the top. This allows the user to switch page, print and return to the report index page with the list of features to select from. This toolbar can be hidden if necessary by clicking the Pages menu > Advanced.
A major new version of InstantAtlas Report Builder (version 2.0) is now available. Report Builder 2.0 is a complete redesign and rebuild of the application, keeping all that was good from version 1 whilst making the reports faster to load, easier to create, more responsive to different devices and more accessible to a range of users.
Continue reading IA Report Builder 2.0 – 22 April 2021 Release Notes
This article describes how to use data from the InstantAtlas National Data Service in Microsoft Power BI. The National Data Service is delivered as ArcGIS Online feature layers.
The steps for using data in ArcGIS in Power BI are described here. It is possible to use the steps in the Appendix to bring data from the National Data Service into Power BI.
However, when using data from the National Data Service specifically, a better result can be achieved using a custom query in the Power BI Advanced Editor. The steps for doing this are described below.
Sign in to the Data Catalog Hub and use the Data Explorer app to search for the indicator you are interested in. Click on any of the tabs and click the button to view the item in ArcGIS Online.
In ArcGIS Online, on the item overview page, click the layer corresponding to the geography you want to display data for in Power BI. Then click the Copy button on the right to copy the URL.
Amend this URL (e.g. in Notepad) to add this to the end:
query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json
The URL should now look something like this:
https://services1.arcgis.com/HumUw0sDQHwJuboT/arcgis/rest/services/Suffolk_Pop_Est_Female/FeatureServer/0/query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json
Open Power BI Desktop and click Get Data, Web. Paste your URL into the URL box and click OK.
You will get something like this:
Click Transform Data. The Power Query Editor will open. Click Advanced Editor.
Replace the query in the Advanced Editor with the one below. Make sure you adjust the URL at the start of the query (shown in red) to the one you are actually using.
let
Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://services1.arcgis.com/HumUw0sDQHwJuboT/arcgis/rest/services/Suffolk_Pop_Est_Female/FeatureServer/0/query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json"), null, null, 65001)}),
#"Parsed JSON" = Table.TransformColumns(Source,{},Json.Document),
Column1 = #"Parsed JSON"{0}[Column1],
fieldSet = Column1[fields],
fieldNames = List.Transform(fieldSet, each Record.Field(_, "name")),
fieldAliases = List.Transform(fieldSet, each Text.Combine({Text.Replace(Record.Field(_, "alias"), "|", " | "), " (", Record.Field(_, "name"),")"})),
features = Column1[features],
#"Converted to Table" = Table.FromList(features, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"attributes"}, {"Column1.attributes"}),
#"Expanded Column1.attributes" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.attributes", fieldNames, fieldAliases)
in
#"Expanded Column1.attributes"
Click Done.
Note that the data type for the columns is text. You should change this for the data you wish to use. Select the columns in question, right-click, Change Type and choose the appropriate type.
Then click Close & Apply in the ribbon.
You can then create your visualisation with the data from the feature layer.
Crime data (May) updated 1 July. All affected reports updated by 6 July.
The following education data was updated in July and relative reports updated by the 29th of July:
Claimant Count (June) updated during July.
April 2019 to March 2020 Annual Population Survey (APS) updated during July. Reports updated by the 22nd of July.
A detailed breakdown of statistics included within the APS is listed below:
HMRC and DWP’s previous statistics relative to children in low income families have been replaced and deprecated to provide a more coherent picture of this category for both Relative and Absolute Low Income.
Latest data for Children in Low Income Families Data has been updated on the 21st of July, from financial year 2014/15 to 2018/19.
The latest version of InstantAtlas Data Catalog (version 2.1.3) is now available at https://hub.instantatlas.com/.