I used to use the advanced setting 'blanks_to_zeroes' to make sure all my cells would be filled, instead of having blank cells when value is zero. However, I've been trying to use blanks_to_zeroes in 2 different google sheets to new queries, but Supermetrics keeps giving me back blank cells. Even queries exactly similar to already exisiting queries elsewhere in the sheet, where the already existing query does still have the 'zeroes', but the new query gives me blank cells.
Is there an error with this advanced setting or is there anything else that might cause the problem?
Thanks in advance!
any solution to this ?