Color rules for target value
Best Answer
-
So if you have the following columns of data:
Categories
Value
Target
You could accomplish your goal by splitting the Value field into two different BeastModes:
'Below'
CASE WHEN `Value` < `Target` THEN `Value` END
'At or Above'
CASE WHEN `Value` >= `Target` THEN `Value` END
Now set the `Categories` field to your 'Names' section on the Bullet Chart, the `Below` beastmode to 'Actual Value' section, the `At or Above` beastmode to the 'Range1 Value' and `Target` to 'Target Value'.
Now in your color rules set `Below` to always red, and `At or Above` to always green.
That should be all you need. If not, just let me know.
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
Ok, so to do that you'll need to break your `value` column into two separate columns like below:
Below Target BeastMode:
CASE WHEN `value` < `target` THEN `value` END
Above Target BeastMode:
CASE WHEN `value` >= `target` THEN `value` END
Now use one of those in your 'Actual Value' field and the other in your 'Range 1 Value' field. Color them using the rules accordingly so that below is always red and the above one is green.
Let me know if you need additional detail in setting this up.
Good luck,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
So if you have the following columns of data:
Categories
Value
Target
You could accomplish your goal by splitting the Value field into two different BeastModes:
'Below'
CASE WHEN `Value` < `Target` THEN `Value` END
'At or Above'
CASE WHEN `Value` >= `Target` THEN `Value` END
Now set the `Categories` field to your 'Names' section on the Bullet Chart, the `Below` beastmode to 'Actual Value' section, the `At or Above` beastmode to the 'Range1 Value' and `Target` to 'Target Value'.
Now in your color rules set `Below` to always red, and `At or Above` to always green.
That should be all you need. If not, just let me know.
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2 -
Thanks,
This worked for the most part. I've attached the image of the output. The only issue I am running into is putting the 'Below' in the ACTUAL VALUE field and the 'Above' in the RANGE1 VALUE field.
Is there a work around for this where both are actuals?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 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