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!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...