field color change based on field value not working in dashboard

[wangkevin1029]

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

[wangkevin1029]

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, 

[ITWhisperer · Accepted solution]

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]

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

[wangkevin1029]

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