| 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.
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.
Returning "No results found" in pie chart but displaying the count in single value visualisation
Can you please share your sample XML?