Solved
How can we get this to display zero - Query failed: Your query returned no data
Using supermetrics for G sheets. I have several queries that don't return any data... YET, however they will do in the near future.
Is it possible to get Supermetrics to save the query and return a zero "0" value to the cell? Currently I get the error message below and the query isn't saved :-(
Query failed: Your query returned no data
I have tried ticking "Replace blank metric values with zeros"
Thanks
Hi Jon,
Try using the Advanced setting:
STORE_ERROR_QUERY
It may still give the error in the cell instead of a 0, but at least you can save the query configuration to use later.
-Thank you
Supermetrics Team