show value in case of no results found

[avivn]

hello,
I'm trying to do a stats count command and to show "0" (for single value chart) instead of N/A in case the query gets no results found.
i tried fillnull but nothing happened.

thank you

[sundareshr]

Try this

base search returning single value | append [| makeresults | eval samefieldasreturnedbybasesearch=0] | head 1

[richgalloway]

If there are no results from your query there is nothing for fillnull to fill.

Try this, replacing processCount with the field from your stats command:

your base search | appendpipe [ stats count | eval processCount=0 | where count==0 | fields - count ]