https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92033#M5013 <P>You can use |eval range=case(..) to deal with strings</P> <P>Example:<BR /> |eval range=case(fldColor=="green", "low", 1==1, "severe") </P> Wed, 18 May 2016 22:47:34 GMT swaraj_appala 2016-05-18T22:47:34Z https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92031#M5011 <P>I want to use a rangemap to create a single value panel. The issue is that the field I want to colur hold string values (e.g. "Colour_1", "Colour_2" or "Colour_3")</P> <P>rangemap requires numbers. Is there a way to fiddle with the strings to get them to work with rangemap?</P> <P>sourcetype="ANM_UK_Grocery" fldDX="DX_1" fldBank="Bank_1" | head 1 | table fldColour,fldBank,fldDX | rangemap fldColour=Color low="Colour_1" severe="Colour_2" elevated="Colour_3"</P> Mon, 28 Sep 2020 11:30:51 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92031#M5011 aleem 2020-09-28T11:30:51Z https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92032#M5012 <P>I used the following command to change Colour_1 to 1</P> <P>eval fldColour=replace(fldColour, "Colour_", "")</P> <P>Works fine</P> Wed, 14 Mar 2012 16:46:21 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92032#M5012 aleem 2012-03-14T16:46:21Z https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92033#M5013 <P>You can use |eval range=case(..) to deal with strings</P> <P>Example:<BR /> |eval range=case(fldColor=="green", "low", 1==1, "severe") </P> Wed, 18 May 2016 22:47:34 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Rangemap-with-String-Values/m-p/92033#M5013 swaraj_appala 2016-05-18T22:47:34Z