Hello Guys,
I have a pie chart in my dashboard, so whenever the search returns nothing, the pie chart should convert into single value visualization showing count as 0. And if there are any results from the search, pie chart should remain as it is.
Currently it shows no results found whenever the search returns nothing.
Can anyone help me with this problem?
Many Thanks in advance.
Since the query is returning nothing, there is nothing to chart. Add this snippet to your search to force a count of zero when there are no results. Change the 'foo' and 'bar' fields to fields in your current query.
| appendpipe [ stats count | eval foo="Nothing found" | eval bar=0 | where count==0 | fields - count ] | ...
Thanks for your answer, but how will this convert pie chart into single value? this is in my dashboard panel, under chart tag the query is written
It won't change the type of chart. You'll still see a pie chart, but that's better than "No results found", right?
when count is 0, its not showing pie chart, it is showing "numeric data required"
Check the field names in the appendpipe
command. You may have foo and bar mixed up.
nope, they are fine, and still same result:( is there any other way to display 0 whenever the search returns nothing?