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
Try this
base search returning single value | append [| makeresults | eval samefieldasreturnedbybasesearch=0] | head 1
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 ]