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].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.