User guide

© GeoWise Ltd. 2011
Page 110
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
For associates:
ElementType
Element
IndicatorDate
Theme Name|Indicator Name|Associate Name|Date
IndicatorDate
Indicator Name|Associate Name|Date
Indicator
Theme Name|Indicator Name|Associate Name
Indicator
Indicator Name|Associate Name
Indicator
Theme Name|Indicator Name|*
Indicator
Indicator Name|*
Indicator
Theme Name|*|Associate Name
Indicator
* |Associate Name
Theme
Theme Name|Associate Name
Theme
*|Associate Name
Theme
Theme Name
Theme
*
E.6.2.2. Setting a Data Type for Associates
The main indicator value data type is controlled in the iadatasheet and can
be either numeric or categoric (see section ‘E.5.1.3. Entering Indicator
Values (Columns C Onwards)’, sub-section ‘Row 4’). Where a data type is
not supplied for an associate, the type will default to numeric. Should you
wish to change the default setting for each associate, you can do this either
in the iadatasheet in the cell directly above the associate column (row 4) or
alternatively you can supply metadata (Figure 136). The data type controls
how a particular data value is presented (such as alignment) and how it is
sorted (numerically or categorically). The type for associates can be set on
theme, indicator and time period level.
Figure 136
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’.
For the data type of associates, the same syntax rules apply as for
precision settings (please refer to the table ‘For associates’ in the previous
section.
E.6.2.3. Setting Custom Legends
It is also possible to set custom classifications for individual themes,
indicators or time periods. You can also set custom colours and labels for
the display of the custom classification within a dynamic report.
Furthermore you can define that a theme, indicator or time period appears
with a specific legend classifier or legend palette by default.
Custom classifications are defined in the ‘Metadata’ worksheet in the Excel
Data Manager. The following image (Figure 137) shows a screenshot of
the ‘Metadata’ worksheet in an instance of the Excel Data Manager. A
custom classification is set up for ‘Indicator 1’ which is a numeric indicator
and for ‘Indicator 4’ which contains categoric values. The default legend
classifier for ‘Indicator 2’ is set to Equal Interval and the default legend