How can i remove the "OTHER" in geostats result ,i tried to add userother=f but its not working. Is there any other way to remove it.
Here's my sample search
index="test" |geostats latfield=lat longfield=lon latest(cpu) by city
Please enlighten me.
Thanks in Advance!
Hi Everyone,just found the answer. I added globallimit=0 in my search and it works.
globallimit=Controls the number of pies in the pie-chart. All other split-by values will be grouped under "OTHER".Setting globallimit=0 will remove all limits and all columns will be rendered
Maybe you can try adding the fields at the end of your search:
index="test" |geostats latfield=lat longfield=lon latest(cpu) by city | fields - OTHER
As you know, it is not the best practice exclude files after doing your search, but for now you can try this solution.
I hope this will help