User guide

© GeoWise Ltd. 2011
Page 149
visualise | communicate | ENGAGE The InstantAtlas Area Profile Template
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
‘Include Dates?’. You might then want to see the time periods displayed in
the spine chart. You can either change the column with the Name
‘indicatorName’ to ‘indicatorDateName’ to see both the indicator name and
the time periods together in one column. Alternatively you can include a
column with the Name ‘date’ to see only the time periods in a column of the
spine chart.
Target data (in the Properties section of the Spine Chart Properties) – this
will generally be ‘target’. If you have an associate called ‘target’ in the XML
data file(s) for your dynamic report the associate values will be used to
draw vertical bars denoting the target an area should achieve.
I.2.2. Data Preparation
An example of how you should prepare your data is provided in the Excel
workbook called IAworkbookAreaProfile_SpineChart.xls. This is located in
the ‘workbooks’ folder of your InstantAtlas software. The default location
for this is:
C:\Program Files\GeoWise\InstantAtlas\workbooks.
The required data structure is shown in the worksheet called ‘iadatasheet’
and is shown in Figure 176.
Figure 176
By default, the horizontal bars in the spine chart are configured to use an
associate called ‘diff’. Although these values can represent anything you
like we recommend that they are the percentage difference between the
indicator value for the base geography area and the indicator value for the
comparator. The comparator can be anything you like but is typically a
national or regional average - it must be the same for all base geography
areas.
In the example above (fictional data), the ‘diff’ values for each indicator are
the percentage difference between the Edinburgh post code sectors values
and the Scotland value. In this case Scotland would be the comparator.
The percentage difference can be calculated in the following way:
100 * ((base area indicator value – comparator value) / comparator value)
By default, the HTML version of the Area Profile template opens up
showing the indicators of the selected date. You can change this to
display either the most resent date of each indicator (irrespective of
the selected date) or all dates. The Spine Chart property for this is
called ‘Display Indicators For’. You can choose whether or not the
time periods should be displayed in brackets behind this indicator
names by using the property ‘Display Dates in Profile’.