topic Re: Query to change the color to dashboard table panel values as per condition in Dashboards & Visualizations

Query to change the color to dashboard table panel values as per condition

Satheesh_red — Mon, 17 Jul 2023 06:33:46 GMT

Hi,

The dashboard table panels contain 4 columns (Host,user,A,B). how to query it to do percentage of the values and if the below criteria are met and change the panel values with orange and red color if percentages are met by user and host.

if A > 80% of B, then color code A to Orange; if A > 90% of B, then color code to Red.

Regards,

Satheesh

Re: Query to change the color to dashboard table panel values as per condition

gcusello — Mon, 17 Jul 2023 07:16:13 GMT

Hi @Satheesh_red,

you have to:

open your dashboard in Edit Mode
click on thepen icon in the column to highlight colours
Choose Colour and Ranges,
set the renges and the relative coluours you like for your values.

Ciao.

Giuseppe

Re: Query to change the color to dashboard table panel values as per condition

Satheesh_red — Mon, 17 Jul 2023 09:19:03 GMT

thanks for the reply @gcusello

Unfortunately, when I click on edit the dashboard, I don't see the option called color and ranges, this seems odd, but I'm not sure.

First, I have to make them % criterion and then moving on to color changing modes dependent on thresholds reached.

Regards,

Satheesh

Re: Query to change the color to dashboard table panel values as per condition

gcusello — Mon, 17 Jul 2023 09:26:13 GMT

Hi @Satheesh_red,

let me summarize:

you opened the Edit Mode ,
you have a table panel,
you clicked on the pen (in the top right of the panel) ,
You haven't the colour choice .

is it correct?

Ciao.

Giuseppe

Re: Query to change the color to dashboard table panel values as per condition

Satheesh_red — Mon, 17 Jul 2023 10:37:23 GMT

your right @gcusello , Not able to see color option.

Re: Query to change the color to dashboard table panel values as per condition

gcusello — Mon, 17 Jul 2023 11:08:55 GMT

Hi @Satheesh_red,

you're clicking on the wrong button, click on the pen in the column header, not the one on the top roght of the panel.

Ciao.

Giuseppe

Re: Query to change the color to dashboard table panel values as per condition

Satheesh_red — Mon, 17 Jul 2023 11:13:18 GMT

thanks @gcusello got it now, But i need to do the below check before i changed the values to color, any query reference. please help.

if A > 80% of B, then color code A to Orange; if A > 90% of B, then color code to Red.

Re: Query to change the color to dashboard table panel values as per condition

gcusello — Mon, 17 Jul 2023 11:22:18 GMT

Hi @Satheesh_red,

considering that the B values are always 100, you could set the following ranges:

min to - 80 -> green
from 80 to 90 -> yellow
from 90 to max -> red

this is the code:

Ciao.

Giuseppe

Re: Query to change the color to dashboard table panel values as per condition

Satheesh_red — Mon, 17 Jul 2023 15:02:37 GMT

Hi @gcusello

In my situation, B values are not 100; but, for clarity, I mentioned that values are 100.

So, basically, I'm going to compute the average and define the color ranges.

Please let me know if there is any way we can set it by query itself along with colors.

Regards,

Satheesh

Re: Query to change the color to dashboard table panel values as per condition

gcusello — Tue, 18 Jul 2023 07:02:33 GMT

Hi @Satheesh_red,

It's possible to define a colour range only for the values of one celle or column, in other words, if B chan have a value different than 100, you should add a new column calculating A/B and use colour range on this column.

Ciao.

Giuseppe