You can alter this configuration once you have published a report by opening the config.xml file using the Designer.<\/p>\n It is possible to show a variable number of columns in the spine chart and each one can be configured separately. The properties that can be set for each column are described below:<\/p>\n Alias<\/strong> \u2013 the heading displayed for the column.<\/p>\n Width<\/strong> \u2013 this will be the width of the column as a percentage of the whole chart.<\/p>\n Name<\/strong> \u2013 this will define the data source for the column. If the column should display indicator values (i.e. thematically mapped values) the value should be \u2018value\u2019. If the column should display associate values, the Name should be the name of the associate exactly as in the JSON data file(s) for your dynamic report (e.g. \u2018diff\u2019 or \u2018baseline\u2019). From version 6.10.0 onwards, spine chart columns can also show values from comparsion features. For this to work, the Name needs to contain the ID of the comparison feature (without the # symbol).<\/p>\n If you wish to show symbols, stand alone, in a column you will need to define the Name as ‘symbol(symbolValue:associate name)<\/span>\u2019 where associate name refers to the name exactly as in the JSON\u00a0data file(s) for your dynamic report (e.g. \u2018trend\u2019 or \u2018state\u2019). You can define the actual symbols for the values in the properties section of the Spine Chart Properties.<\/p>\n If you wish to show symbols and text within the same column you will need to define the Name as:<\/p>\n symbol(symbolValue:associate name,textValue:value)<\/span><\/p>\n Note that \u201cassociate name\u201d refers to the name exactly as in the JSON\u00a0data file(s) for your dynamic report (e.g. \u2018trend\u2019 or \u2018state\u2019). The \u201cvalue\u201d refers to either the indicator value or if you would like it to show the symbol with the text of an associate value you should change \u201cvalue\u201d to the associate name exactly as in the JSON\u00a0data file(s) for your dynamic report (e.g. \u2018trend\u2019 or \u2018state\u2019).<\/p>\n You can also define the alignment of the symbol using \u2018symbolAlign:{right, left, centre}\u2019, for example:<\/p>\n symbol(symbolValue:state,textValue:value,symbolAlign:right)<\/span><\/p>\n or<\/p>\n symbol(symbolValue:trend,symbolAlign:center)<\/span><\/p>\n By default, the name of a selected map feature will be shown in one of the columns of the spine chart and also in the Selected Features Legend above the spine chart.<\/p>\n Having multiple time periods for each indicator is optional.\u00a0By default, the Area Profile template opens up showing the indicators of the selected date. You can change this to display either the most recent date of each indicator (irrespective of the selected date) or all dates. The Spine Chart property for this is called \u2018Display Indicators For\u2019. You can choose whether or not the time periods should be displayed in brackets behind the indicator names by using the property \u2018Display Dates in Profile\u2019.<\/span><\/p>\n You may wish to display a symbol over the bars of the spine chart to denoting the target an area should achieve. These target values would usually be set up as an associate column in your data file(s) – please see an example in the Data Preparation<\/a> section below. In the Spine Chart Properties in the Designer you can define up to four targets. Each target is defined by a ‘Shape’, ‘Colour’, ‘Size’, ‘Label’ and ‘Data’. The ‘Target Data’ property needs to match the name of the associate column from your data.<\/p>\n You can also display the values of a comparison feature as targets in the spine chart. In this case the ‘Target X<\/em> Use Comparison Feature’ property (where X<\/em> is the number of the target 1-4) needs to match the ID of the comparison feature (without the # symbol).<\/p>\n In most cases, administrators will want the indicator value of the comparison feature to be used rather than an associate value, hence you should enter ‘value’ into the Target X<\/em> Data<\/strong> property (where X<\/em> is the number of the target 1-4). Alternatively, you can pick up associate values of the specified comparison feature. In this case enter the name of the associate column you wish to use.<\/p>\n There are many other properties for the spine chart that can be changed to further tailor the appearance\/functionality. You can move your mouse pointer over property names in the Designer to see a description. If you are not sure what a particular property is used for please contact your support provider.<\/p>\n An example of how you can prepare your data is provided in the Excel workbook called IAworkbookAreaProfile_SpineChart.xls. This is located in the \u2018workbooks\u2019 folder of your InstantAtlas software. The default location for this is:<\/p>\n C:\\Program Files\\EsriUK\\InstantAtlas\\workbooks.<\/p>\n The required data structure is shown in the worksheet called \u2018iadatasheet\u2019 and is shown in the figure below.<\/p>\n By default, the horizontal bars in the spine chart are configured to use an associate called \u2018diff\u2019. These values can represent anything you like and it is up to you to populate the column accordingly.<\/p>\n It is possible to set up the report so that it calculates the % diff values as a percentage difference between the indicator value for the base geography area and the indicator value for a 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 and all indicators<\/p>\n For this functionality, the Spine Chart contains a setting in the config.xml file called Comparison Id For Calculating Bar Value<\/strong>. Enter here the code of the comparison feature as defined in column A of your Geographies and Filters worksheet (if using the Excel Data Manager) but without the # character.<\/strong><\/p>\n As in this case you are not providing an associate with the % diff values, you should change the Bar Data<\/strong> property to ‘value’ (or a relevant associate column name). The same column will be used for the comparison feature.<\/p>\n If the new property is filled with a valid comparison ID, the percentage difference values will be calculated using the following formula:<\/p>\n 100 * ((base area indicator value \u2013 comparator value) \/ comparator value)<\/p>\n This will give you positive difference values where the base area value is higher than the comparator value and negative difference values where the base area value is lower than the comparator value.<\/p>\n It is currently not possible to display the calculated % diff values as numbers in a separate column of the Spine Chart.<\/p>\n The \u2018target\u2019 associate is optional. If you include target values these will be shown as little vertical markers superimposed on the horizontal bars. These will show whether the target for a particular indicator has been reached or not. If you do not include the \u2018target\u2019 associate, these markers will not show.<\/p>\n In addition to \u2018diff\u2019 and \u2018target\u2019 associates, you can include any others associates described in section \u2018The InstantAtlas Excel Data Manager\u2019, sub-section \u2018Entering Associate Values<\/a>\u2019 (e.g. \u2018ll\u2019, \u2018ul\u2019 or \u2018count\u2019) or your own custom associates.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Configuration With this configuration the main chart is configured to be a spine chart. This has a central spine and horizontal bars to either side of this that show whether indicator values for the selected area(s) are above\/below a given comparison value. If you publish this with a demonstration data file the report will look … Continue reading Area Profile – Spine Chart<\/span><\/a><\/p>\n","protected":false},"author":22,"featured_media":0,"parent":5361,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-5381","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/comments?post=5381"}],"version-history":[{"count":0,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5381\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5361"}],"wp:attachment":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/media?parent=5381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2019\/05\/SpineChartReport.png\")
<\/a><\/p>\nCustomising the columns of the chart<\/h3>\n
Setting the time periods to show<\/h3>\n
Defining target symbols<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nData Preparation<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n