Conditional formatting in a table card
I like to show all data below target < 0 in Red and above in Green >0 in a Table card. Is it possible to do this?
Comments
-
Hi all,
Can anybody help @HelenOBrien with their question?
Thanks!0 -
can anyone help
0 -
There is currently no option to display colors in a table card using the functionality present in the Domo interface. That said, it is technically possible to do it using HTML and beast modes, but that's not an approach we recommend you take. I wish I had a better answer for you than that.
Nevertheless, I can definitely see the value of having the ability to do conditional formatting within a table card. That would be a very useful feature. To recommend new functionality for Domo, please visit the Dojo Ideas Exchange. You can search existing ideas and then vote for it if it matches what you have in mind. If you can't find it, please create a new idea, which can then be voted on by your fellow Dojo members by clicking the white arrow next to the idea.
** I work for Domo1 -
@HelenOBrien, did RabidCougar's reply help you out?
0 -
CASE
WHEN `FieldName` < 0
THEN CONCAT('<div style="background-color:#bbe491; text-align: right; text-decoration:none; font-weight: bold; width: 100%; height:100%; margin:-20px; padding:20px;"><a href="#">',`FieldName`, '</a></div>')
WHEN `FieldName` > 0
-- THEN CONCAT('<div style="background-color:#fcbcb7; text-align: right; text-decoration:none; font-weight: bold; width: 100%; height:100%; margin:-20px; padding:20px;"><a href="#">',`FieldName`, '</a></div>')
END1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive