User guide

Page 144

visualise | communicate | ENGAGE Multiple Geography Reports

g the InstantAtlas Area Profile Template User Guide

Note that the geography names given in cell B2 of the Geography and

Filters worksheet must be unique, e.g. each base geography needs a

unique name.

If the areas in your geographies nest, you may wish include filters that

reflect this nesting. In this way, geographies lower in the hierarchy can be

filtered according to which area in a higher geography they nest within. For

example in a report with Edinburgh post code districts and post code

sectors it makes sense to include a Districts filter in the post code sectors

workbook. A filter that is available at multiple geographies will stay applied

as you switch between these geographies.

If you want the map palettes to vary based on the visible base

geography and its associated data, please see section ‘E.6.2.3. Setting

Custom Legends’ in the Excel Data Manager area above, or section 3.8.2

of the Access Data Manager User Guide.

In the normal way, export a data file from each workbook separately. It is

imperative that the data files for the geographies are named in a way that

matches their order on the ‘Choose Your Base Geography’ screen of the

Publisher. We recommend you name them ‘data1.xml’, ‘data2.xml’,

‘data3.xml’,… where ‘data1.xml’ is the XML file for the uppermost

geography, ‘data2.xml’ is for the next one down and so on.

The next step is to merge these files into a single data.xml / data.js file.

The Excel Data Manager add-in provides an ‘IA Merge Files’ button for this

(Figure 173).

Figure 173

Click this button. The ‘Select files to be appended’ dialog allows you to

browse to the folder containing your data files. Select the files by clicking

and holding down the ‘Shift’ or ‘Ctrl’ keys on your keyboard. Then click

‘Open’ (Figure 174).

If you are publishing a report using an HTML template, you need to

export the data files into JSON format and chose respective naming

(‘data1.js’, ‘data2.js’, ‘data3.js’,…).