stats min(count) not 0 if value never occurs

[viggor]

If I have the following query

foo
| timechart span=60s  count 
| stats min(count) as minCntFoo

but foo never occurs, is there a way of setting minCntFoo=0 instead of now, where I get "No results found."?

[cmerriman]

try this:

foo
 | timechart span=60s  count 
 | stats min(count) as minCntFoo
| appendpipe [ stats count | eval minCntFoo=0 | where count==0 |table minCntFoo]

the appendpipe stats command will count the number of events that come back and only bring back results if there are 0 events from the base query.