Count offers two ways to highlight table data:
Text-level highlighting – This will change the color of the text
Full cell background highlighting – This changes the background color of the entire cell
You can use SQL’s CASE statement to apply conditional logic and return values that can be highlighted in tables visualisations.
How to color individual values in a table
With the custom table visualisation, you can easily change the color of your text mark by adjusting settings in the right-hand panel.
First, set up your thresholds using a CASE statement (you can do this in a SQL cell or a calculated field!) to create a new column, then use this column to automatically change the color of your table's text mark based on the values.
How to color individual rows in a table
Similar to the text coloring, we can make use of marks in the custom table visualisation to easily change the background colors of rows by adjusting settings in the right-hand panel.
Set up your thresholds using a CASE statement to create a new column, then use this column to automatically change the color of your cell background.
