Bar Diverging Stacked Chart Tutorial
Options
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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive