Spine Chart Tutorial

Pris

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

Screenshot: