Results not consistent from google

  • Resolved masterslate

    (@masterslate)


    10 years ago

    Not sure if this is something on the plugin side or on googles side, but it seems like some of my charts are changing and returning inconsistent results, despite no changes to the tables.

    For example, I have a column with 10 rows, each is 0 except for three rows with the values of 6, 2, and 4. Let’s call this column E (all integers). Column B is the corresponding name for that row of data.

    Using this query “SELECT B, G where G %3E 0 order by G desc limit 5” one would expect three results ordered like so: 6,4,2.
    Sometimes I get that result. Other times I get no results returned.

    I’ve tried removing the limit with no luck. I have not tried removing the order by, as it started returning correct results during my testing.

    Let me know if there is any more data I can provide.

    Thanks again for your awesome work and great support!

    https://www.ads-software.com/plugins/inline-google-spreadsheet-viewer/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter masterslate

    (@masterslate)

    After some hard searching, it seems to be this reported bug:

    https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1759

    Thread Starter masterslate

    (@masterslate)

    As a workaround, I have copied the entire contents of the sheet into a second sheet, using the “paste special -> paste as values” menu.

    However, this means the data is not as dynamic as I was hoping. On the bright side, this is not the fault of the plugin, but rather googles api endpoint. Hopefully it will be fixed soon.

    Plugin Author Meitar

    (@meitar)

    Huh. Yeah, that didn’t sound like a plugin bug, given the intermittent behavior. Glad to see you got to the bottom of it and that Google already knows about it, though. I hope they resolve the issue quickly. Thanks for adding the link to that bug report on this thread.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Results not consistent from google’ is closed to new replies.