How to select which Metric should go on Line in a Line + Bar Graph?

I have a chart where one Metric is $ and rest all is Numbers. How do I graph it in a way where the $ shows as Line and other show on Bar graph.

(Like how in Excel we do a secondary axis)

In the picture below, its taking the 1st one(USB requests) as Line while I want to show the Red Bar as Line with $

Best Answers

  • jdorsch2
    jdorsch2 Member
    edited April 2023 Answer ✓

    Domo takes the first value and sets it as the line for this chart, so you could create a beast mode that ranks your KPI values. You could do something like this:

    CASE WHEN KPI = 'Website Cart Revenue'

    THEN 1

    ELSE 2

    END

    Then you can put this beast mode in the sorting section under the filter section. This should make the Website Cart Revenue KPI the first value and show up as the line! You can also assign specific number values to the rest of your KPIs if you want them in a specific order too.

  • DashboardDude
    Answer ✓

    Hi @SaloniShah ,

    I made a video for you to show you how I did it: https://www.loom.com/share/274a18fccf744eb789818ad70d4245e9

    John Le

    You're only one dashboard away. 

    More video solutions at: https://www.dashboarddudes.com/pantry

    John Le

    You're only one dashboard away.

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

Answers

  • jdorsch2
    jdorsch2 Member
    edited April 2023 Answer ✓

    Domo takes the first value and sets it as the line for this chart, so you could create a beast mode that ranks your KPI values. You could do something like this:

    CASE WHEN KPI = 'Website Cart Revenue'

    THEN 1

    ELSE 2

    END

    Then you can put this beast mode in the sorting section under the filter section. This should make the Website Cart Revenue KPI the first value and show up as the line! You can also assign specific number values to the rest of your KPIs if you want them in a specific order too.

  • DashboardDude
    Answer ✓

    Hi @SaloniShah ,

    I made a video for you to show you how I did it: https://www.loom.com/share/274a18fccf744eb789818ad70d4245e9

    John Le

    You're only one dashboard away. 

    More video solutions at: https://www.dashboarddudes.com/pantry

    John Le

    You're only one dashboard away.

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

  • Thank you so much!