How to set different thresholds for different rows in grafana table. Is it possible

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?
    I want to set different thresholds for different rows in the table panel

  • How are you trying to achieve it?
    Currently if we apply field override, it apply the threshold for the whole column .

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

1 Like

What is your data source. Also what are the elements you want to use within the row to set threshold

Can you share columns for a few rows?

Could you please check the sample table we have.

Our source is argus , our internal company data source.

I found one old thread( 2 year old) , with same requirement . However there were no conclusion.

so what do you want to happen on which row? I am not seeing the difference between any of those rows?

Like, for 1st row, threshold will be 40 , if anything > 40 for 1st row, it will be red.
for 2nd row, threshold will be 250 , anything > 250 will be red,
similarly different threshold values for 3rd and 4th rows.

1 Like

is there something that indicates/differentiates 1st row and 2nd row? some data point?

I have the same requirement, so hypothetically there is a data point that differentiates this (e.g.):

The above data has different site priority and we can have the MAX threshold included as a data column.
All sites have the same 100 seconds of outage, but each site has different thresholds:

  • Site A has breached the treshold of 60 seconds so should be red
  • Site B has ALMOST breached the treshold of 120 seconds so should be orange
  • Site C is way below the treshold of 600 seconds so should be ok = green

How can we set these different thresholds?

PS: The above datapoints simulated in Excel.

The Grafana version and operating system you are using, as well as the specific outcome you want to achieve. You mentioned that applying a field override sets the threshold for the entire column, which is not the desired behavior.

That could be partially workarounded (entire row would be colored, not particular column) if you can add additional column into your query that provides necessary color:

And then use Config from query result transformation:

The reason why this approach can’t be applied to single column is due to values in it in this case are the same. Details can be found here: