To get 0 values, even though you get blank results in your query, write "blanks_to_zeroes" in to advanced settings: