How to map rangefield query to colors in pie chart?

[ritupatil02]

| rangemap field=perc low=0-90 medium=90-95 high=95-100

<option name="charting.fieldColors">{"low":"0xdc4e41","medium":"0xf1813f","high":"0x53a051"}</option>

I have written the above query but not getting the desired result

Can anyone please tell what is wrong?

Thanks. 

[kamlesh_vaghela]

@ritupatil02 

Can you please try this?

<panel>
      <chart>
        <search>
          <query>| makeresults count=3 | eval a=1 | accum a | eval perc = case(a=1,90,a=2,95,a=3,99) | table perc | rangemap field=perc low=0-90 medium=91-95 high=96-100 | table range perc</query>
          <earliest>1623390960.000</earliest>
          <latest>1623394584.000</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.chart">pie</option>
        <option name="charting.fieldColors">{"low":"0xFF0000","medium":"0x00FF00","high":"0x0000FF"}</option>
      </chart>
    </panel>

Just observe the search and usage of range,

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

[ritupatil02]

Returning "No results found" in pie chart but displaying the count in single value visualisation

[kamlesh_vaghela]

@ritupatil02 

Can you please share your sample XML?