How do you set panel specific color ranges for single value visualizations that contain a % sign in Splunk 6.3?

[pepper_seattle]

Hello,

Splunk 6.3 allows you to set colors by ranges with a hard coded min and max setting that you can eval in your search (possibly else where too?), but it appears that if you are using a single value visualization with percentages that include the % sign, the coloring won't work properly (black background instead of green or red). In previous versions I've used

| fieldformat <field> = <field> . " %" 

to get around the % sign changing a value to a string, but this doesn't work with this case.

Question:
How do you set panel specific color ranges for single value visualizations that contain a % sign in Splunk 6.3?

[mporath_splunk · Accepted solution]

Fieldformat is not recognized for Single Value in 6.3.
You could set the "%" as an "After Label", and leave the number as is.

[pepper_seattle]

Thanks @mporath, I found the labeling quite useful to get around this. Just unfortunate that it can't also be done through querying.