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
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 384 Distribute
- 110 Domo Everywhere
- 268 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive