Start a new topic
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

1 Comment


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

Login or Signup to post a comment