Customer range / color for Table data

[jason_hotchkiss]

Hello - 

When choosing color ranges for table cell values, is there a way to specify the from min to be any other value other than 0?  I would like min to = 70.  

I went through this: https://docs.splunk.com/Documentation/Splunk/latest/Viz/TableFormatsFormatting#Format_table_columns

but I did not see an option.  I

I also went through this:  https://docs.splunk.com/Documentation/Splunk/latest/Viz/TableFormatsXML

and found not mention of it.  

Thought I would ask here.  Thanks!

colorrange.png

[ITWhisperer]

What colour would you use if the value was below 70? If the value can't be below 70, then it doesn't matter what colour you use for this range.

[jason_hotchkiss]

@ITWhisperer 

I would like it to be transparent.  I tried using #FFFFFF00 but that didn't work.  I have it currently set to white.  But with the rows alternating color between white & gray, it looks kind of ugly.  

Ugly.PNG

[ITWhisperer]

You can use hidden multi-value elements to specify the colour you want and the map the value to a real colour. Have a look at what was done here https://community.splunk.com/t5/Splunk-Search/How-to-color-the-columns-based-on-previous-column-valu... you can probably adopt a similar approach