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
Unfortunately it doesn't work
Hi Sayrin,
This setting only helps save the configuration in the case that an error or "no data" situation is preventing it from being recorded. There's currently no way to turn that into a 0 or other value if the data source does return a "no data" error. It will fill the data in as the error until the "no data" state is no longer true.
If you need further assistance, please submit a private ticket:
https://support.supermetrics.com/support/tickets/new
-Thank you
Supermetrics Team