I am no database expert, but i can do sql queries on influxdb at beginners level.
I am wondering if DB query has no results to return,is it possible by any means or functions like IS NULL or coalesce, i can return a default value.
My query pulls the row counts, if the condition matches…but some times there are no records matching the criteria, hence no counts. i need default value to be returned at this point.
Looking forward for possible solution.