Column color changed based condition in splunk dashboard

[singhrakesh]

Hi All,

I am quite struck in one of the requirement as Column color has to changed based on condition.

Activity Percentage Percentage_2hr
A 53.79464286 53.84615385
B 43.67559524 42.51447477
C 39.88095238 37.88254756
D 36.68154762 36.14557486
E 36.60714286 35.07030604

If percentage >= OR < Percentage_2hr then Activity and Percentage color column will be changing.

[singhrakesh]

Thanks Dindu for your response but lookup file while based on backend query.

I already tried the suggestion but its not working. I think it need to go with dashboard followed by splunk js

[dindu]

Hi Rakesh,

This has been already addressed in the forum.
Please check
https://answers.splunk.com/answers/670546/how-to-change-color-of-entire-row-based-on-field-v.html
https://answers.splunk.com/answers/588394/change-the-color-of-rows-in-a-table-based-on-text-1.html

Hope this helps!!

[dindu]

Hi Rakesh,
If you are using a Splunk version 6.5 or higher - you can do it from UI.
Click on the brush icon next to the table header upon choosing the edit dashboard. It will give a color option. Click on that
Choose range and entry the values for the range and desired colors.

Edit Dashboard --> Click on the brush Icon next to the column header -->Choose Color -->Select "Range" from drop down -->Enter the range of values -->Save.

Please refer to the URL for more details.
https://docs.splunk.com/Documentation/Splunk/latest/Viz/TableFormatsFormatting.

Please try and let us know