Table Row Color

[shubham2712]

Hi All,

I am unable to color my rows on the basis of value coming in a single column. Is there a way to do that ?

I am using the V7.3.1

Appreciate your help!!!

Thanks,
Shubham

[mattabrams]

Hi @shubham2712,

The documentation on the table panel will help you color rows the way you’d like.

You should also check out this nice table on the play.grafana.org sandbox site.

Here’s a screenshot of that panel. I think it’s close to what you want to achieve.

[codlord]

Although you can use thresholds to colour cells, I think the OP wanted a method to colour an entire row based on a specified field.

I don’t think the table panel supports coloured rows.

[shubham2712]

yup correct !!!

I want the whole row colored rather than cell based

[mattabrams]

@codlord is correct, @shubham2712. This feature was supported in older versions of Grafana but is currently not available. There is a workaround to use the old table panel, but I think this might be on the roadmap for Grafana 8. I’ll ask the team and get the details. In the meantime, here is the workaround:

Open your panel JSON.

Find the line reading: "type": "table",
Change the line to: "type": "table-old",

This will load the old Angular table visualization.

Now edit your query and scroll down to Panel ==> Options ==> Thresholds ==> Color Mode. Select Row. Now you can colorize an entire row!

More soon on whether or not this feature is returning.

[mattabrams]

@shubham2712 ,
I spoke with the frontend team and I don’t think this feature will get implemented for the Grafana V8 release, but it is now on our backlog

[shubham2712]

Hi @mattabrams can we create a pivot table using Grafana ?

I am unable to do that!!! Can you please help?

[mattabrams]

Hi @shubham2712,

you might be able to achieve what you want, but it probably depends on the details of your situation. For instance: what is your datasource and what are you trying to achieve?

I would read these two related topics and see if they help you transform your data how you’d like:

Multiple timeseries, pivot column

Grafana is able to produce graphs out of a single query with result set such as rows of times and value, in order to have another graph we can add a second query on the same graph like: q1) SELECT time, value FROM test WHERE series_name = ‘A’; q2) SELECT time, value FROM test WHERE series_name = ‘B’; the issue is that in some cases we don’t know in advance the name of series and most of all how many series we have, the ideal would be to do: SELECT time, series_name, value FROM test; and t…

Pivot Table & Styleing

Found a way to do the Pivot in SQL: SELECT User, ROUND(SUM(IF(Month = 'January', Profit, NULL)),2) AS Jan, ROUND(SUM(IF(Month = 'February', Profit, NULL)),2) AS Feb, ROUND(SUM(IF(Month = 'March', Profit, NULL)),2) AS Mar, ROUND(SUM(IF(Month = 'April', Profit, NULL)),2) AS Apr, ROUND(SUM(IF(Month = 'May', Profit, NULL)),2) AS May, ROUND(SUM(IF(Month = 'June', Profit, NULL)),2) AS Jun, ROUND(SUM(IF(Month = 'July', Profit, NULL)),2) AS Jul, ROUND(SUM(IF(Month = 'August', Profit, NULL)),2) AS Aug,…

~m

[wfjm]

I also ran into this question of how to color a whole row based on a property of a column value.
And see

@codlord wrote

This feature was supported in older versions of Grafana but is currently not available.

@mattabrams wrote

I spoke with the front-end team and I don’t think this feature will get implemented for the Grafana V8 release

This is now the third time I read

• was available in Table(old)
• but is not available in the current Table

[mattabrams]

upvote this feature request:

Colorize Rows in Table Panel · Discussion #38151 · grafana/grafana