Line plus grouped chart - getting Y axis and 1st series on left scale, 2nd series on right scale
Hi there,
On the attached image, the Y axis value and the first series value are counts.
Y axis = count of all orders (the blue line)
First series column = count of delayed orders (the green bars)
The second series column = (count of all orders - count of delayed orders)/count of all orders. Or, in other words, the percent of orders that are not delayed.
So, since the Line and the Green bar are both counts, and the orange bar is a percent, I'm trying to figure out a way to have the line and the green bar represented on the left side scale, and the percent on the right side scale.
But, in the picture, only the line is on the left scale, while the green bar is represented on the right scale.
Not sure if this is possible.
Best Answer
-
The closest thing you can do is to choose Sync Value Scales under the General Chart Properties. This will make the left and right be the same.
I would think it would make more sense to have your percentage field be the line and your two order counts be the bars in the series. You'd then be able to format the line as a percentage and it would be more evident between which values are percentage and which values are counts.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
The closest thing you can do is to choose Sync Value Scales under the General Chart Properties. This will make the left and right be the same.
I would think it would make more sense to have your percentage field be the line and your two order counts be the bars in the series. You'd then be able to format the line as a percentage and it would be more evident between which values are percentage and which values are counts.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
I agree with @MarkSnodgrass
put your percentage value first and it’ll be displayed as a percentage and have a separate scale from your other two counts with your counts on the same scale.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive