Hi HMTODD,
try this run everywhere search to see an example how it can be done:
| gentimes start=-1
| eval severity ="1 2 3"
| makemv severity
| mvexpand severity
| rename comment AS "Here starts the real code"
| eval red=case(severity="1", 1, severity="3", 3, 1=1, null()), yellow=case(severity="2", 2, 1=1, null())
The first 5 lines just create fake events and the eval created a field called red or yellow based on the severity field. You can process the results further and remove the severity field with table or fields if it's not needed. You can also another eval to get a field called green if needed.
Hope this helps ...
cheers, MuS
... View more