Stacked Bar Chart with Line Graph

lauramiddleton
lauramiddleton Member
in Charting

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

image.png
Tagged:

Best Answer

Answers

  • ArborRose
    ArborRose Coach

    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)
    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • lauramiddleton
    lauramiddleton Member

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

    image.png
  • ArborRose
    ArborRose Coach

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

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • lauramiddleton
    lauramiddleton Member

    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
    DashboardDude Coach
    Answer ✓

    @lauramiddleton

    I made you a video answer:

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

    Hope this helps

    Circle.png

    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:

    https://www.dashboarddudes.com/newsletter

Categories