Thanks. The big win for me was the case command. Here is a bit of detail on my problem and how it has been solved with your help.
I wanted to create a single color pie chart that would be red OR yellow OR green depending on the value of the field named severity. The search results that I am working with is a single field, severity, and the value, either a 1, or 2, or 3.
I solved this with the following.
eval color=case(severity="1","red",severity="2","yellow",severity="3","green") | chart count by color
combined with this customer pie chart option
<option name="charting.fieldColors">{"red":0xff0000,"yellow":0xf58f39,"green":0x65a637}</option>
Works great. Thanks.
... View more