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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive