Supermetrics Support Forum

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

Login to post a comment