User guide

© GeoWise Ltd. 2011
Page 109
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
in the ‘Example Metadata’ worksheet. To activate this worksheet you
would need to rename it to ‘Metadata’.
E.6.2.1. Setting the Precision for Indicators and Associates
InstantAtlas version 6 reports support a precision value for each indicator
and associate. An example can be seen below (Figure 134):
Figure 134
Figure 134 shows how you can set a precision value for an indicator (row
2) or an associate (row 3). In the example above, the main indicator value
will display with 1 decimal place, whereas the associate value ‘count’ will
always be shown with two decimal places. Please note that precision is
only used where the data type is numeric.
Precision settings can be defined on a theme, indicator and time period
level. Figure 135 shows an example of how to set different precision
values for an associate column called ‘count’ for two different time periods
for the same indicator.
Figure 135
If your indicator names are not unique, you can address this by adding the
theme name in front of the indicator name in column B. Both must be
separated by a pipe symbol, e.g. ‘Theme 1|Male’.
The following tables show the syntax of possible settings. The settings are
hierarchical: a Theme is overridden by an Indicator, and an Indicator is
overridden by an IndicatorDate. A setting that is higher in the list will
always overwrite a setting from lower down for the particular element. For
example if you set a theme to have a precision of 2, and also specify an
indicator of this theme to have precision of 0, then the latter will overwrite
the former for this particular indicator. In the tables below a * symbol is
used as a wild-card and means any theme, indicator or associate column.
The wild-card option is only valid for the precision and type metadata
elements.
For themes / indicators / dates:
ElementType
Element
IndicatorDate
Theme Name|Indicator Name|Date
IndicatorDate
Indicator Name|Date
Indicator
Theme Name|Indicator Name
Indicator
Indicator Name
Indicator
Theme Name|*
Indicator
*
Theme
Theme Name
Theme
*