I have the working query:
=ArrayFormula(QUERY(C1:C&{"",""},"select Col1, count(Col2) where Col1 != ''
group by Col1 label count(Col2) 'Count'",1))
I would like to order it by the count(Col2), but have been unable to figure
out what I am doing wrong. I tried:
=ArrayFormula(QUERY(C1:C&{"",""},"select Col1, count(Col2) where Col1 != ''
group by Col1 label count(Col2) 'Count' order by count(Col2) desc",1))
and I get:
ErrorUnable to parse query string for Function QUERY parameter 2:
PARSE_ERROR: Encountered " "order" "order "" at line 1, column 83. Was
expecting one of: <EOF> "format" ... "options" ... "," ...
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/63470d7e-ebcc-44a3-ab7f-85f7744f6a20%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
