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
-
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.
2 -
Hi @SaloniShah ,
I made a video for you to show you how I did it:
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:
1
Answers
-
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.
2 -
Hi @SaloniShah ,
I made a video for you to show you how I did it:
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:
1 -
Thank you so much!
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive