Can I make a grouped bar chart with 2 series/categories?
Hello! I am currently trying to make a grouped bar chart that is also stacked. In this scenario I want to compare our power and core members and within those groups how many of each are a website client with us. If they are a website client, I want that bar to be stacked to show what type of website that member has.
This is what I get when I do a simple group chart and use Website Client (True/False) as the series. If I change the chart type to "Grouped + Stacked" I get one series field option so I just dropped the Website Type over the top of the Website Client field and got this:
This looks how I want the chart to look except the values completely changed. For reference, 186 on the top picture now says 100 on the bottom. Is this an impossible task or is there possibly a better way to do it?
Thanks in advance!
Best Answers
-
This is possible using the Grouped and stacked vertical bar chart type. The default for the chart is to have the first of the series as a bar to the left (the blue bar in your example) with the rest in the series stacked to the right of it. So this chart type will produce what you are looking for but will require you doing some ETL work to format the data properly. You'll need a field to distinguish between Core and Power which I think you already have. You'll also need to order your data so that non-website clients are in a grouping that is labeled to come first in ascending order. Something like this:
Note that when the grouping is sorted in ascending order the Non-client will be first, making it the left bar with the remaining values being stacked to the right.
If I solved your problem, please select "yes" above
0 -
Formula for Series Grouping field:
CASE WHEN `whatever your field is called` = 'whatever the name is of non-clients' THEN 'a. Non-client' ELSE `whatever your field is called` END
If I solved your problem, please select "yes" above
0
Answers
-
This is possible using the Grouped and stacked vertical bar chart type. The default for the chart is to have the first of the series as a bar to the left (the blue bar in your example) with the rest in the series stacked to the right of it. So this chart type will produce what you are looking for but will require you doing some ETL work to format the data properly. You'll need a field to distinguish between Core and Power which I think you already have. You'll also need to order your data so that non-website clients are in a grouping that is labeled to come first in ascending order. Something like this:
Note that when the grouping is sorted in ascending order the Non-client will be first, making it the left bar with the remaining values being stacked to the right.
If I solved your problem, please select "yes" above
0 -
@colemenwilson That helps a lot, thank you! Do you know what that formula looks like? I am getting caught up on making a calculation for that. I am hoping I can add this as a column to a list view.
0 -
Formula for Series Grouping field:
CASE WHEN `whatever your field is called` = 'whatever the name is of non-clients' THEN 'a. Non-client' ELSE `whatever your field is called` END
If I solved your problem, please select "yes" above
0 -
@colemenwilson You rock, I was able to successfully make it. Thank you for your help!!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive