Conditional formatting based on multiple columns

I want to compare two columns and their values in a card.
I have column A and B. I want to apply color rules on the lower value cell between the two cells.
I know you can set the color rules based on individual columns. I know you can create a beast mode and set a flag for the conditions. I currently have the color rules applied on the row, but the user only wants it to apply to the cell on each row.
Is there any other solution to accomplish this specific use case?
Thanks,
Saket
Best Answer
-
Applying color rules at the cell level based on the comparison of two columns directly is not directly supported. As you mentioned, you can try to create a beast mode calculation that compares the values of columns A and B and sets a flag accordingly. Then, apply color rules based on the flag.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
Applying color rules at the cell level based on the comparison of two columns directly is not directly supported. As you mentioned, you can try to create a beast mode calculation that compares the values of columns A and B and sets a flag accordingly. Then, apply color rules based on the flag.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 792 Beast Mode
- 78 App Studio
- 44 Variables
- 754 Automate
- 187 Apps
- 479 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive