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

Tagged:

Best Answer

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! **

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

  • 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! **

  • 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
    Answer ✓

    @lauramiddleton

    I made you a video answer:

    Hope this helps

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry