Charting
Charting
Conditionally formatting colors of horizontal bar chart for over/under budget
I am trying to figure out how to conditionally format my "Actual" sales either green/red for over/under "Budget" by location. Is this possible? I know this may have to be done with a beast mode (unsuccessful so far) as it cannot be done in chart properties.
Welcome!
Best Answer
-
You can use the Color Rules to do this. This is found in the chart properties. It would look something like this.
**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.0
Answers
-
You can use the Color Rules to do this. This is found in the chart properties. It would look something like this.
**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.0 -
Hi @davidwong ,
Just to clarify, you want the blue bars to change to red or green dependent on if an actual hits a target number right? However, is that target different per location or is the same across the board?
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
John @DashboardDude, that is correct. So I would need a conditional format or beast mode of some sort. The color rules wouldn't work because they are stagnant number inputs I believe (like greater than #, or less than #). Any insights?
0 -
Hmm yeah I don't think this chart is going to work for you because of the stagnant color. However if you use the bullet chart, you can set different goals per item. So that way you can see if something passes the goal or not.
It's an option: You can see horizontal bullet charts on this page I made
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
Gotcha, I experimented with the bullet visualization at one point but there's too much variation in each of my locations' (y axis) target value (budget). I appreciate the response.
0 -
Feel free to schedule 30 sometime with me and we can see if we can find a solution:
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive