https://community.splunk.com/t5/Splunk-Search/How-to-get-rangemap-to-change-the-color-of-bars-based-on/m-p/206288#M60032 <P>how do I change the colors of my bar chart to red, yellow, and green? Here is my query:</P> <PRE><CODE>index=xyxy env=PROD profile=blah heap_used=* total_heap_size=* | stats last(heap_used) AS heap_used, last(total_heap_size) AS total_avail by host | convert num(heap_used), num(total_avail) | eval heap_perc = tostring(round((heap_used/total_avail)*100,2)) + "%" | convert num(heap_perc) | table host heap_perc | rangemap field=heap_perc green=0-45 yellow=45-60 red=60-100 </CODE></PRE> <P>My XML for the chart:</P> <PRE><CODE>("red":0xFF0000,"yellow":0xFFFF00,"green":0x00FF00) </CODE></PRE> Thu, 04 Aug 2016 20:55:19 GMT iatwal 2016-08-04T20:55:19Z https://community.splunk.com/t5/Splunk-Search/How-to-get-rangemap-to-change-the-color-of-bars-based-on/m-p/206288#M60032 <P>how do I change the colors of my bar chart to red, yellow, and green? Here is my query:</P> <PRE><CODE>index=xyxy env=PROD profile=blah heap_used=* total_heap_size=* | stats last(heap_used) AS heap_used, last(total_heap_size) AS total_avail by host | convert num(heap_used), num(total_avail) | eval heap_perc = tostring(round((heap_used/total_avail)*100,2)) + "%" | convert num(heap_perc) | table host heap_perc | rangemap field=heap_perc green=0-45 yellow=45-60 red=60-100 </CODE></PRE> <P>My XML for the chart:</P> <PRE><CODE>("red":0xFF0000,"yellow":0xFFFF00,"green":0x00FF00) </CODE></PRE> Thu, 04 Aug 2016 20:55:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-rangemap-to-change-the-color-of-bars-based-on/m-p/206288#M60032 iatwal 2016-08-04T20:55:19Z https://community.splunk.com/t5/Splunk-Search/How-to-get-rangemap-to-change-the-color-of-bars-based-on/m-p/206289#M60033 <P>Use this query</P> <PRE><CODE>index=xyxy env=PROD profile=blah heap_used=* total_heap_size=* | stats last(heap_used) AS heap_used, last(total_heap_size) AS total_avail by host | convert num(heap_used), num(total_avail) | eval heap_perc = tostring(round((heap_used/total_avail)*100,2)) + "%" | convert num(heap_perc) | table host heap_perc | eval green=if(heap_perc&gt;0 AND heap_perc&lt;=45,heap_perc,0) | eval yellow=if(heap_perc&gt;45 AND heap_perc&lt;=60,heap_perc,0) | eval red=if(heap_perc&gt;60 AND heap_perc&lt;=100,heap_perc,0) | table host green yellow red </CODE></PRE> Thu, 04 Aug 2016 21:12:14 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-rangemap-to-change-the-color-of-bars-based-on/m-p/206289#M60033 somesoni2 2016-08-04T21:12:14Z