conditional formatting color based upon another field value

I have a Symbol + Grouped Bar chart that I would like to use conditional colors.
X Axis is Customer
Y Axis is (Max)Goal
Series is (Avg) PercentOnTime
I would like to do the following:
If (Series) PercentOnTime >= (Y Axis) Goal = (Series) Green
If (Series) PercentOnTime < (Y Axis) Goal = (Series) Red
Any help would be greatly appreciated.
Best Answer
-
I do not think this is possible using the existing color rules in analyzer.
However, you might want to take a look at Adding Graphics, Links, and Images to Table Cards Using Beast Mode from the knowledge base. The same logic (using CONCAT in beast mode to insert html code) may apply and help you achieve what you want.
HTH
0
Answers
-
I do not think this is possible using the existing color rules in analyzer.
However, you might want to take a look at Adding Graphics, Links, and Images to Table Cards Using Beast Mode from the knowledge base. The same logic (using CONCAT in beast mode to insert html code) may apply and help you achieve what you want.
HTH
0 -
Thank you. I will take a look at that.
0 -
did you figure this out?
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive