https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113392#M1678 <P>Because the field "prop" is not existing anymore. You can add the "as" on your command to name it as prop again.</P> <P>Something like this.<BR /> | geostats values(prop) as prop by StateName globallimit=0</P> Thu, 08 Mar 2018 09:22:33 GMT jaracan 2018-03-08T09:22:33Z https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113389#M1675 <P>Hi All.</P> <P>I want alerts to be displayed on map for easy understanding. <BR /> i have used this Query </P> <PRE><CODE>source="Churn_Map.csv" sourcetype="Churn_map" | eval Churn = if(Churn="True.","1","0") | eventstats sum(Churn) as true_churn , count(Churn) as total_churn by state | eval prop= true_churn*100 / total_churn | geostats values(prop) by StateName globallimit=0 | rangemap field=prop green=0-5 yellow=6-10 orange=11-15 default=red </CODE></PRE> <P>but colors are not displaying as i defined. any improvements.?<BR /> the values are from min 5 to max 20. so i need alerts to seen on pie charts on map,by default it is showing some colors.<BR /> Green : 0-5<BR /> Yellow : 6-10<BR /> Orange :11-15<BR /> Red : 16 and above.<BR /> any reference documents and links are really appreciated <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>Thanks,<BR /> Santhosh.</P> Tue, 19 May 2015 06:27:14 GMT https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113389#M1675 SanthoshSreshta 2015-05-19T06:27:14Z https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113390#M1676 <P>Can you please check the answer provided in <A href="http://answers.splunk.com/answers/232462/how-to-display-a-range-in-color-good-or-fault.html">http://answers.splunk.com/answers/232462/how-to-display-a-range-in-color-good-or-fault.html</A></P> Tue, 19 May 2015 08:27:32 GMT https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113390#M1676 vganjare 2015-05-19T08:27:32Z https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113391#M1677 <P>I am not able to understand that @vganjare </P> Tue, 19 May 2015 08:36:39 GMT https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113391#M1677 SanthoshSreshta 2015-05-19T08:36:39Z https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113392#M1678 <P>Because the field "prop" is not existing anymore. You can add the "as" on your command to name it as prop again.</P> <P>Something like this.<BR /> | geostats values(prop) as prop by StateName globallimit=0</P> Thu, 08 Mar 2018 09:22:33 GMT https://community.splunk.com/t5/Alerting/How-to-define-colors-as-per-ranges-using-rangemap-in-geostats/m-p/113392#M1678 jaracan 2018-03-08T09:22:33Z