Stacked Bar Chart with Line Graph
We want to show 'Wins and Losses' by year as show in the below snapshot, but we want to also split these 'Wins and Losses' again by another series "Retain/Capture".
Ideally, we wanted to add a line for the count of the opportunities if possible.
Is this doable on a chart type?
Thanks
Best Answer
-
John Le
You're only one dashboard away.
Click here for more video solutions:
1
Answers
-
I'm not sure if I understand the question. Does this help?
Year
Outcome
Type
Count
2023
Win
Retain
50
2023
Win
Capture
30
2023
Loss
Retain
20
2023
Loss
Capture
15
2024
Win
Retain
60
2024
Win
Capture
35
2024
Loss
Retain
25
2024
Loss
Capture
10
outcome and type:
CONCAT(Outcome, ' - ', Type)
retain:
SUM(CASE WHEN `Type` = 'Retain' THEN `Count` ELSE 0 END)
wins:
SUM(CASE WHEN `Outcome` = 'Win' THEN `Count` ELSE 0 END)
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
Thank you @ArborRose. I was ideally looking to split the bar like this, split the Wins and Losses per Retain or Capture?
0 -
Okay…I get it. Something like this Domo blank brick….
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
Yes something like that, we can do one chart for COUNT, and I can do another one for $ VALUE.
How do I apply this?
Thanks
0 -
John Le
You're only one dashboard away.
Click here for more video solutions:
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