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.html#aggregation_functions
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.
