Hi, Thanks for your reply.
I am trying to convert column C which is in time format to a numerical type and get the sum of all the values. Is there a way to do that ? On Feb 3, 6:59 am, VizWiz <[email protected]> wrote: > Hi, > > Applying an aggregation function to a scalar function is not allowed. The > other way around is valid, though. > You can read more about it > here:http://code.google.com/apis/visualization/documentation/querylanguage... > > Cheers, > VizWiz > > > > On Wed, Feb 3, 2010 at 9:06 AM, Weydson <[email protected]> wrote: > > Hi, > > > I am trying to build a query to use on a Google Spreadsheet but > > somehow it looks like it's not accepting it. The query is: > > > =QUERY(B2:C150, "select sum(hour(C)) pivot B") > > > and I get the following error: > > > error: Invalid query: Query parse error: Encountered " "(" "( "" at > > line 1, column 16. Was expecting: ")" ... > > > That only happens if I use nested functions such as sum(hour()). Any > > ideas? > > > -- > > 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]<google-visualization- > > api%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en. -- 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.
