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

SaloniShah

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 $

jdorsch2

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

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

jdorsch2

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

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

SaloniShah

Thank you so much!