Colour condition for words in a string
Hi Folks,
Does anyone know how to create a beastmode that colour conditions each word in a string within a single cell for a table visual?
For example:
These values have to remain joined by the '/' delimiter so I won't simply separate them into columns.
All responses appreciated
Kind regards,
Answers
-
You could utilize an HTML table and utilize HTML code to colorize each value in your string. You'd need to CONCAT the HTML code together with your values and conditionally set the color. I've done a previous writeup on this here: https://dojo.domo.com/main/discussion/52684/domo-ideas-conference-beast-modes-conditional-formatting#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
You could also utilize a regular expression to modify your string and automatically insert the HTML code.
Something like this might work assuming your values are actual colors (untested)
REGEXP_REPLACE(`RAG History`, '.*((Yellow)|(Red)|(Green)).*', '<div><span style="color: $1">$1</span></div>')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@GrantSmith Thanks I'll give it a try and update this thread.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive