Rangemap with String Values

[aleem]

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")

rangemap requires numbers. Is there a way to fiddle with the strings to get them to work with rangemap?

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"

[swaraj_appala]

You can use |eval range=case(..) to deal with strings

Example:
|eval range=case(fldColor=="green", "low", 1==1, "severe")

[aleem · Accepted solution]

I used the following command to change Colour_1 to 1

eval fldColour=replace(fldColour, "Colour_", "")

Works fine