Spine Chart Tutorial




edited October 5 in Charting

Spine charts split a single value into 2 contrasting components (e.g. Male/Female).

How to build in Analyzer:

  1. Select 'Horizontal Bar' under 'Popular Charts' as the Chart Type
  2. Create Calculated Field named '-National Count'
    1. (CASE WHEN Gender = 'F' THEN -SUM(National Count) ELSE SUM(National Count) END)
  3. Drag '-National Count' to X-Axis
  4. Drag 'Name' into 'Y Axis'
  5. Drag 'Gender' into 'Series'
  6. Turn on Tooltips. Drag 'National Count' into 'Tooltip Field 1'
  7. In Chart Properties, configure the following:
    1. General -> Sort on Totals: Descending
    2. Gridlines -> 'Hide Gridlines' checked
    3. Gridlines -> 'Remove Min/Max/Avg Lines' checked
    4. Data Label Settings -> Text as %_VALUE
    5. Data Label Settings -> Position: Inside Right
    6. Data Label Settings -> 'Use Scale Format' checked
    7. Data Label Settings -> 'Use Scale Abbreviation' checked
    8. Value Scale (X) -> Show Label as 'Never'
    9. Hover Text Settings -> Hover Text as %_CATEGORY_NAME | %_SERIES_NAME : %_TOOLTIP1