Problem with grouped and stacked chart. Need Help
I am pretty new to Domo and could not find a way to do what I am looking for.
I would want to group the data by country (grouped age field) and then stack the survey results. Here is an example of what my data looks like.
Best Answer
-
To my knowledge, you are not able to create a custom hierarchy for data fields, which is what I believe would be required to create the visualisation you are looking for.
However, I started by normalizing your data (collapse collumn in ETL) to create something like this:
Then I created a grouped bar chart and used country as a quickfilter:
This lets you view all countries together, or you can select a single country to view the data for that country:
0
Answers
-
This is a lot of data to consume in one visualization. Have you considered splitting this up into multiple cards? Or, if you are going to present from Domo, you could start with a higher level view of the survey results and build out a drill path that would get to the level of detail you want.
0 -
I would want them to be in a single card. Excel does it so easily. I believe that a little tweaking could help me get the output I am looking for. But I am not sure what that should be.
0 -
To my knowledge, you are not able to create a custom hierarchy for data fields, which is what I believe would be required to create the visualisation you are looking for.
However, I started by normalizing your data (collapse collumn in ETL) to create something like this:
Then I created a grouped bar chart and used country as a quickfilter:
This lets you view all countries together, or you can select a single country to view the data for that country:
0 -
This should do for me. Thank You for helping me out.
0 -
Sounds like you want to create a card that looks like this:
If so, you can do so using a stacked bar chart and dummy records to do the grouping (and normalized dataset shown in previous reply):
1.) Create a concatenated field for the x-axis (Country and Age Group in this instance)
2.) Create a dummy record for each space ("Europe 0", "UK 0", USA 0")
3.) Create a display field that contains spaces in the dummy records and the value of the concatenated field for all other records (note: each dummy record has to have a different number of spaces... otherwise they all get displayed as one space on the chart)
4.) Use the display field for the x-axis, but sort by the original field
5.) y-axis is counts and series is response
Kinda klunky from a support perspective, though.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K 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
- 748 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
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 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