User guide

Page 107

visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager

g the InstantAtlas Area Profile Template User Guide

Figure 131

The ‘count’ and ‘state’ associates in the ‘Example 2 iadatasheet’ worksheet

are examples of custom associates that can be added. When mapping

rates it is good practice to show counts alongside them in the data table.

You can add a ‘Count’ column to the data table of your report using the

InstantAtlas Designer and configure it to pick up an associate in the data

file called ‘count’ (see section ‘C. The InstantAtlas Designer’, sub-section

‘C.4.3.5. Table Properties’ for more information). The same applies to the

‘state’ associate respectively.

By default associate columns are assumed to be of type numeric. If you

have associate columns with textual data you should change the type to be

categoric. You can do this either in the iadatasheet in the cell directly

above the associate column name (row 4) or alternatively you can define

the type in the ‘Metadata’ worksheet. Please refer to section ‘E.6.2.2.

Setting a Data Type for Associates’ for further information.

E.6. The Metadata Worksheet

Including metadata in your data XML files is optional (unless you are

creating data file for InstantAtlas Server). However, there are two reasons

why you might include metadata:

 Metatext – this metadata will be shown within the ‘metatext’ text

box in your InstantAtlas dynamic reports. This is a useful way of

displaying theme, indicator, or time period specific notes or tips on

the report page itself.

 Indicator display metadata – this metadata will define how an

indicator is displayed in your reports.

From version 6.4.0 onwards you can have multiple Metadata worksheets

which might be helpful if you want to structure your metadata into logical

groups. A metadata worksheet becomes active when its name starts with

‘Metadata’.

E.6.1. Adding Metatext

The format for entering metatext is shown below (Figure 132).

Figure 132