Grafana Table – Conditional cell color based on comparison of two columns

[skmlmis]

In a Grafana Table visualization using version 12.3.1, I have two numeric columns (Column A and Column B).

I want to apply conditional formatting such that:

• If Column A > Column B, then Column A cell background should be red

• Else, Column A should remain white (default)

  

  If yes, please share the recommended approach.

[ebabeshko]

Try this approach:

[Table Panel][InfluxDB] change the cell color in Column A based on the values in other columns

You can try to use Config from query results transformation. In the example below (InfluxDB datasource) I added extra column with color that is populated basing on true / false value from column C: [query] And applied transformation and override for Cell type: [transformation] It’s possible to hide this extra column using additional transformation: [transformation]

[carlocea9]

Looks like Col B value is a static 3.50? If so, would setting the “threshold” value to 3.5 work for you?

Unless the threshold is dynamic and could potentially change?

[aryangoswami023]

How to Highlight the Cell with Maximum Value Dynamically

Steps to create highlight in cell Step 1: Create table in database in my case (PostgreSQL) and insert data in it. [image] Step 2: Create new dashboard in Grafana and then select your data source to fetch the data. • Click on Add Visualization [image] • Select the datasource [image] Step 3: Select table visualizations to show the data on panel using this query. [image] SELECT “device_name”, “00_hours”, “04_hours”, “08_hours”, CASE WHEN “00_hours” = MAX(“00_hours”) OVER () THEN…