Dashboards & Visualizations

How to update table cell color as per the another field?

rally0321
Path Finder

Dear all,

I have below table, FieldA (String) FieldB to FieldE (Numeric). Can we base on the FieldA value to change color for FieldB to FieldE?

rally0321_1-1654016989515.png

logic will  below

1. update cell for Field B as red when (FieldA = "1111" or "3333" or "4444") and FieldB cell value >0

2. update cell for Field C as red when (FieldA = "2222" or "3333" ) and FieldC cell value >0

3. update cell for Field D as red when (FieldA = "2222" or "3333" ) and FieldD cell value >0

4. update cell for Field E as red when (FieldA = "4444" ) and FieldE cell value >0

 

 

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Essentially, the technique is to create a multi-value field with a tag for the colour you want to be used, then use format/colorPalette to set the colour and some CSS to hide the extra value in the multi-value field

See this solution https://community.splunk.com/t5/Splunk-Search/How-to-change-table-cell-background-color-depends-on-s... 

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Essentially, the technique is to create a multi-value field with a tag for the colour you want to be used, then use format/colorPalette to set the colour and some CSS to hide the extra value in the multi-value field

See this solution https://community.splunk.com/t5/Splunk-Search/How-to-change-table-cell-background-color-depends-on-s... 

Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...