User guide

Page 100

visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager

g the InstantAtlas Area Profile Template User Guide

So you can provide a link to geography metadata on a feature by feature

basis.

In the example workbook, the link ‘notes.htm’ is provided for each feature.

This means that when the notes icon is clicked for any feature, a file called

‘notes.htm’ located in the report folder will open. You can use absolute

pathnames (e.g. ‘C:\notes.htm’) or relative pathnames (e.g.

‘../../notes.htm’). If you intend to move your report folder it is best to put all

external files you wish to link to into the report folder and specify relative

pathnames to them in column C.

With relative pathnames, ‘./notes.htm’ means that ‘notes.htm’ is located in

the report folder whereas ‘../notes.htm’ means that ‘notes.htm’ is located in

the parent folder. And ‘../../notes.htm’ means that ‘notes.htm’ is located

two levels above the report folder.

The following image (Figure 123) illustrates some examples of links that

could be entered using absolute and relative pathnames.

Figure 123

E.4.4. Entering Filter Information (Columns D Onwards)

By making entries in columns D onwards, you are able to define filters for

your report. Row 1 should contain ‘filter’. The entry in row 2 should be the

name of the filter. Any text you enter in a filter column becomes a value

within that filter. When you click a filter value under the Filter menu of your

report, only geographic features with that filter value will be displayed.

In the example provided, there is one filter called ‘Zones’ (Figure 124). It

has five values: Edinburgh Centre, North, South, East and West. This

would give you a filter in the report looking like that shown in the following

image. Clicking ‘Edinburgh West’, for example, would result in only post

code sectors in Edinburgh West being displayed in the report.

In InstantAtlas HTML dynamic reports the notes icon appears in front

of the feature names in the same column (Figure 122). If your data

does not contain a link in column 3 of the Geography and Filters

worksheet for a certain geographic feature, no notes icon will appear

in front of the name of this feature.

Figure 122