Bullet chart color rules by amounts
I am using a bullet chart to compare Estimated (BOV) to Actual (Amount) amounts. I'd like to color the bars based on BOV vs. Amount: yellow if BOV <Amount, green if BOV =Amount, and red if BOV >Amount. Any idea where to start?
I setup 3 beast mode calculations. I just can't figure out how to get them into the chart properly.
Above Goal: CASE WHEN SUM(`RFPBOV`)>SUM(`Amount`) THEN SUM(`RFPBOV`) END
Equal Goal: CASE WHEN SUM(`RFPBOV`)=SUM(`Amount`) THEN SUM(`RFPBOV`) END
Below Goal: CASE WHEN SUM(`RFPBOV`)<SUM(`Amount`) THEN SUM(`RFPBOV`) END
Comments
-
Hello user09847!
What you are trying to do is not currently possible to do with a bullet chart, but I think it's a great idea!
Essentially, instead of comparing column values against static values for color rules, you want to be able to compare column values against the values of other columns.
I suggest you submit this idea to the Dojo Ideas Exchange, so that other users can vote on it and add their input as well. You can find the ideas exchange here: http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas
You can also search existing ideas there, and vote for any you see that would also help you reach your goals.Starlord
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive