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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive