Dashboards & Visualizations

How can I apply color over the cells having special character in values?

mnj1809
Path Finder

Hello,

I've a tabular data like below and I want to color the cells based on the following threshold.
0%-79% ==> Red
80%-99% ==> Yellow
100% ==> Green

mnj1809_0-1683038549693.png

I am applying below but without any success. I know that this is due to % symbol in the values.

<format type="color" field="Passed Rules">
<colorPalette type="list">[#FF9999,#FFE699,#C6E0B4]</colorPalette>
<scale type="threshold">80%,100%</scale>
</format>

So how can I apply colors over the cell?

Thanks in advance.

@ITWhisperer 

Labels (3)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

You can't use range expressions if your data is not numeric and the % sign breaks them, so you have to use an expression. Use this

<format type="color" field="Passed Rules">
  <colorPalette type="expression">case(tonumber(rtrim(value, "%"))>=100, "#C6E0B4",tonumber(rtrim(value, "%"))>80, "#FFE699",true(), "#FF9999")
  </colorPalette>
</format>

which effectively removes the % to calculate each range in the expression.

View solution in original post

0 Karma

bowesmana
SplunkTrust
SplunkTrust

You can't use range expressions if your data is not numeric and the % sign breaks them, so you have to use an expression. Use this

<format type="color" field="Passed Rules">
  <colorPalette type="expression">case(tonumber(rtrim(value, "%"))>=100, "#C6E0B4",tonumber(rtrim(value, "%"))>80, "#FFE699",true(), "#FF9999")
  </colorPalette>
</format>

which effectively removes the % to calculate each range in the expression.

0 Karma

mnj1809
Path Finder

Perfect !!!
Thank you so much @bowesmana 

0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...