Dashboards & Visualizations

field color change based on field value not working in dashboard

wangkevin1029
Communicator

Hi, Splunkers,

I have a field  duration in the panel, I added the following  <format></format> into the panel.

I want this duration field to show different color when it  is greater than 20.

but it doesn't work. 

<format type="color" field="duration">

          <colorPalette type="expression">if(tonumber(value)>20),"#789056")</colorPalette>

</format>

 

thx in advance.

 

Kevin

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

An if function requires 3 arguments if(condition, result if true, result if false) - you only have one, followed by a value outside the if function.

View solution in original post

wangkevin1029
Communicator

Hi, ITWhisperer

 

<colorPalette type="expression">if(tonumber(value)>20, "#789056","#009056")</colorPalette>

I put another color code here, it works.

However, here, I want to keep the original color , if   tonumber(value)>20  is false.

what value should I put here as color code for false?

 

besides, 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

An if function requires 3 arguments if(condition, result if true, result if false) - you only have one, followed by a value outside the if function.

wangkevin1029
Communicator

Hi, ITWhisperer,

 

it works when I just put a “” for false value, then it keeps original color.

<colorPalette type="expression">if(tonumber(value)>20, "#789056","")</colorPalette>

 

Kevin

 
0 Karma

wangkevin1029
Communicator

Btw, the original color in table is alternatively light/dark color every other line.

in this way, not sure how to specify the default color here.

 

Kevin

0 Karma
Get Updates on the Splunk Community!

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...