Return 0 instead of N/A (null) when select count has no results

Question

I'm want to display a KPI in a singlestat panel, based on the following query:

select count(foo) from bar where field = 'value' and time > now() - 1m

Sometimes there are no results (and that's valid), but the singlestat panel shows N/A instead of 0

What can/should I do?

I've tried adding fill (0) but that didn't seem to make any difference. — Robert Barron

IIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIII · Accepted Answer · 2017-01-20T12:22:50

6

votes

You can try to map null to 0 under "Value mappings"

(You dont have to use range to text)