Bar Diverging Stacked Chart Tutorial
Diverging stacked bar charts, aka Likert scales, are perfect for presenting survey or questionnaire results that involve sentiment (eg disagree, neutral, agreed).
How to build in Domo
1. Start in Magic ETL:
Survey Dataset:
- Input tool: Survey dataset
- Group By Tile:
- Select what columns identify the grouping: Age Group
- Name a new aggregated column: Total Age Group Respondees
- Define how the new column should be aggregated: Number of respondents (Sum)
- Join Data Tile:
- Select tables and join type:
- Left Table: Group By
- Right Table: Survey Dataset
- Join Type: Inner
- Choose the matching columns (keys)
- Age Group to Age Group
- Alter output columns:
- Right Table: Drop column Age Group
- Select tables and join type:
- Formula Tile:
- Create a new column called 'PctOfTotal':
CASE WHEN Response Value < 3 THEN PctOfTotal*-1 ELSE PctOfTotal END
- Update the column 'PctOfTotal':
Number of respondents
/Total Age Group Respondees
- Create a new column called 'PctOfTotal':
- Output Tile: Survey Dataset Transformed
2. Open dataset in Analyzer:
- Select 'Horizontal Bar' under 'Popular Charts' as the Chart Type
- Create Calculated Field named 'Category Sort':
(CASE WHEN Response Value = 1 THEN 'I disagree a lot' WHEN Response Value = 2 THEN 'I disagree' WHEN Response Value= 3 THEN 'I agree' WHEN Response Value = 4 THEN 'I agree a lot' ELSE 'Neutral' END)
- Drag 'PctOfTotal' into 'X Axis'
- Drag 'Age Group' into 'Y Axis'
- Drag 'Response' into 'Series'
- Turn on Tooltips. Drag 'Number of respondents' into 'Tooltip Field 1'
- Drag 'Category Sort' to Sorting. Aggregation: No aggregation
- In Chart Properties, configure the following:
- General -> Sort on Totals: A-Z
- Gridlines -> 'Hide Gridlines' checked
- Gridlines -> 'Remove Min/Max/Avg Lines' checked
- Data Label Settings -> Text as
%_PERCENT_OF_CATEGORY
- Data Label Settings -> Position: Center
- Data Label Settings -> 'Use Scale Format' checked
- Data Label Settings -> 'Use Scale Abbreviation' checked
- Value Scale (X) -> Show Show Label as 'Never'
- Hover Text Settings -> Hover Text as
🔤 %_CATEGORY_NAME | %_SERIES_NAME %_TOOLTIP1 respondees (%_PERCENT_OF_CATEGORY)
Screenshot:
Tagged:
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive