How to use Line + Stacked Bar Chart
Hi Dojos,
Looking for some advice on how to use a Line + Stacked Bar Chart in a specific way.
Currently my chart looks like this:
I want to add a line which indicates the number of clients by region. My dataset is structured as follows (only relevant columns shown):
"Operational Places" is grouped by "ACPR Name" and "Organisation Type". "Number of Clients" is grouped only by "ACPR Name" in a different ETL, hence why the numbers are the same for each ACPR throughout.
The idea is to have something like below:
I've implemented the solution from a similar question that was asked however ran into a different problem with colour rules/legend labels. If I add colour rules for the new Beast Modes that I create I end up with a messy legend:
Appreciate any help or direction
Cheers
Eric
Comments
-
@eric_tetik you should be able to use the stacked bar and line chart, just make sure you put the column you want to make the line in the y-axis spot and put the others in the series spot.
**If this answer solved your problem be sure to like it and accept it as a solution!
0 -
Thanks for your response @Ashleigh
I've already tried that and unfortunately it doesn't work. It does works in this simple form:
However I can't separate the bars into series of "Organisation Type" like the image in the original post.
At best, I just receive various versions of the above. The user in this question ran into the same issue in 2017.
Cheers
Eric
0 -
@eric_tetik are you sorting by any columns?
**If this answer solved your problem be sure to like it and accept it as a solution!
0 -
Hi @Ashleigh
I've tried with and without sorting and neither get me closer to the intended effect. Decided to present the cards differently so no longer an issue, however if you (or anyone) have a solution it'll be great for future reference and other users
Cheers
Eric
0 -
Hi Eric, you could create a separate beast mode field for the Operational Places of each Organisation Type. For example:
sum(case when `Organisation Type` = 'Private' then `Operational Places` else 0 end)
sum(case when `Organisation Type` = 'Not-for-profit' then `Operational Places` else 0 end)
sum(case when `Organisation Type` = 'Government' then `Operational Places` else 0 end)
Once you have these Beast Modes, place each of them in the Series section of the Analyzer and put the "Number of Clients" field in the Y Axis postition.
0 -
Are there any other solutions or work arounds. In my situation I have hundreds+ "types" that need to be stacked. So its not really an effective use of my time to create a BM for each type. The way DOMO has build the use of this chart is not intuitive at all.
0 -
it might benefit you to start a new thread b/c it's unclear if your problems are actually related to the initial issue.
either way.
definitely do not make 100s of beast modes! that would be such a PITA to maintain.
if you have multiple "Types" in one column, experiment with putting Types in "Series" or "Categories". Also, consider a different visualization. if you actually have hundreds of types then it won't make sense to see each individual one in a chart.
If you need to group them so you get down to 5 or 10 unique values, consider use a Beast Mode / CASE statement to group different Types.
Alternatively if you only have a few types of interest, you can alter your data to put the metrics in columns. but personally I think the model you currently have sounds better / more flexible.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
to the original poster / @MichelleH and @Ashleigh , the design of the dataset was flawed which is why the user struggled to solve their problem.
"Operational Places" is grouped by "ACPR Name" and "Organisation Type". "Number of Clients" is grouped only by "ACPR Name" in a different ETL, hence why the numbers are the same for each ACPR throughout."
the big walk away is to try to avoid having columns that are non-additive or semi-additive. (a fully additive column means you could take the whole column, sum it up and get 'the right answer'. in this case, b'c 'number of clients' was duplicated across rows, the column is only semi-additive. (it's the same as if you had a dataset that had one row per month and the balance of the AR account. the balance column is not additive, b/c you cannot sum all balances across all months and get the right answer. in that kind of data structure you'd always want 'the most recent balance.' and that's way more difficult to do in ANY visualization platform.
SOLUTION: split the metrics into a set of rows for "number of clients" and a set of rows for "count of location"
from there it's just a matter of putting ACPR on the X-axis, Organization Type on the Y-axis. and then your metrics on the series.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive