In a table card can I use a value to color code a cell?

mberkeley

Here is the example:

I have a list of customers with 10 columns of data about the customer in a table. One of the columns is a boolean value (T/F). Instead of using a column to display that data, which takes a lot of horizontal space, I would like to have the customer name column change colors (ie: green background for True, red background for False).

Any ideas?

jaeW_at_Onyx

use HTML wrapped in a CASE statement.

CASE WHEN True then CONCAT( '<Div style ... >'...

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Card_Element_Transforms

Note only works with HTML table cards not Mega Tables (therefore will not scroll).

jaeW_at_Onyx

use HTML wrapped in a CASE statement.

CASE WHEN True then CONCAT( '<Div style ... >'...

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Card_Element_Transforms

Note only works with HTML table cards not Mega Tables (therefore will not scroll).

mberkeley

The inability to scroll is a deal-breaker for this table. Thanks for the info though!

mberkeley

The inability to scroll is a deal-breaker for this table. Thanks for the info though!

jaeW_at_Onyx

put a filter card to the left of the link so you can filter the table to a manageable number of rows.