Color rules - logic based on other columns
Often times with color rules, we want to base the color on the value of another column. Few examples:
1) There is a Value Column and a Goal Column:
-When the value is greater than or equal to the goal, color Green
-When the value is less than the goal red
2) Color the Value column by a calculation:
-When the value is under the standard deviation, color green, else red
These examples are very similar as in both cases we would use columns to compare the values to determine the color scale. In either case the goal value or the calculation can be done at the source or in beast mode.
The issue I am seeing is that we cannot build any comparative logic into any card except an HTML table. This is problematic for KPIs in particular because tables are not necessarily a visually pleasing. For everything else you need to hard code the color settings, which is an issue when you have data updating each month and the rules need to change.
Anyone know of a way to perform this logic in visuals other than a table?
Thanks,
Jim
Answers
-
You can do something similar to this by getting creative with a heatmap.
In the heatmap option, I am actually using the % variance as the value that I am graphing and then pulling in the values I want to display as tooltips:
Unfortunately, short of some html tagging, I am not aware of a way to do this within a table.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
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
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 693 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive