Good catch! Unfortunately, I have tried using the column letters from the google spread sheet where the data exists. Example below...
select A, count(B) group by A format A "EEE" options no_values still no luck On Sep 22, 1:25 am, Maksym Barbul <[EMAIL PROTECTED]> wrote: > Hi, I think the problem can be with your column name. > In query > referencehttp://code.google.com/apis/visualization/documentation/querylanguage... > are listed reserved words and 'timestamp' is one of them. So you'd > better not use it as identifier. > > On Sep 22, 6:16 am, Toxin <[EMAIL PROTECTED]> wrote: > > > I have data with the columns: > > > timestamp (e.g. 8/25/2008 10:00:00) > > volume (e.g. 12) > > type (e.g. mountain dew) > > > and I am trying to see what days of the week I drink the most soda.. > > so I started to write the following query > > > select timestamp, count(type) group by timestamp format timestamp > > "EEE" options no_values > > > but I get the following javascript error: > > > this.e is undefined > > [Break on this error] e+Pa);b[e]=true}},O=function(a,b,c) > > {if(b...e=[];for(var b=0;b<this.g[u];b++){var c= > > > if I take out "options no_values", the query works, but then it doesnt > > aggregate by day of the week like I want. > > > what gives? Any suggestions? Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
