Using group by together with format

[Toxin]

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!

[Maksym Barbul]

Hi, I think the problem can be with your column name.
In query reference http://code.google.com/apis/visualization/documentation/querylanguage.html#Reserved_Words
are listed reserved words and 'timestamp' is one of them. So you'd
better not use it as identifier.

[Toxin]

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 <maxbar...@gmail.com> wrote:
> Hi, I think the problem can be with your column name.

> In query referencehttp://code.google.com/apis/visualization/documentation/querylanguage...

[Toxin]

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!