Conditional Formatting on Drill Down Table (option for AND/OR)
I'm drilling into a card that shows me a list of servers and some other information. I'd like to use conditional formatting to change the color of the row based on some characters in the server name field. This is doable if you only have one set of characters however if you have multiple sets of characters to conditionally format, this feature does not work. For example:
I would like conditional formatting to highlight in Red rows that do not contain the following sets of letters for only one of the drill down tables: (Test, Dev)
ServerTest001
ServerDev001
ServerProd001
ServerTest002
ServerDev002
ServerProd002
ServerRandom001
ServerAbcdef001
Is there a way to do this through conditional formatting/beast mode?
Comments
-
I believe that the color rules are currently either applied to an entire data set, or to a specific card. However, when you apply the rules to a card, you also apply them to all of the drill through views of that card.
If you are using a table, you could use html code to create a format for a single cell:
case
when `Field Name` like '%ServerProd001%' then
concat('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', `Field Name`,'</div>')
else `Field Name`
end
This will create a red background when a cell in the `Field Name` column contains the text "ServerProd001". you would need to add another when clause for each of the other values you wanted to highlight
0 -
So that would be good but I'm using a line chart and I only want them highlighted in one specific drill down filter.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 60 App Studio
- 41 Variables
- 687 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive