Stacked Bar Chart with Line Graph

lauramiddleton

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

ArborRose

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)

lauramiddleton

Thank you @ArborRose. I was ideally looking to split the bar like this, split the Wins and Losses per Retain or Capture?

ArborRose

Okay…I get it. Something like this Domo blank brick….

lauramiddleton

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

DashboardDude

@lauramiddleton

I made you a video answer:

https://www.youtube.com/watch?v=gHNk4bimMeU

Hope this helps