Has anyone been able to use the option no_values? no_format works for me in the above query but not no_values. Any query examples with it working?
Any ideas, suggestions? Thanks! On Sep 22, 7:50 am, Toxin <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
