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
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________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
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有