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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive