Dashboards & Visualizations

Dashboard format: color a cell of a column (with different value)

dhirajkumar2121
Loves-to-Learn Lots

Hi!

I  have a dashboard with 10 columns,

If value of column 1 and column 2 is different I have to make it as red color,

Similarly I have to do it for column 3-4, 5-6, 7-8, 9-10.

dhirajkumar2121_0-1710749467034.png

I am using below code but it marking whole column red.(I only need red color for values which is different.)

<format type="color" field="Storenumber" >
<colorPalette type="expression"> if (Storeid!=Storenumber,"#53A051","#DC4E41")</colorPalette>

dhirajkumar2121_1-1710749559034.png

 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

You can do this by extending the cells to be a multivalue field with the colour in the second cell and then hide the second cell with css - this assumes Classic dashboard

Solved: Re: How to color cells based on there values and b... - Splunk Community

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...