Basically what I am trying to do is organize information in a sheet and put some of that information into another sheet, but organizing some of the information horizontally (in rows) when that information was originally in column form. I am trying to do a basic one data-piece query that selects certain names out of a column (given the rules I put in) but, when there are multiple, the resulting names are displayed in a row instead of a column. I have tried the pivot function a bit, but so far I have only managed to get error messages, like the one I posted before.
On Tuesday, October 3, 2017 at 1:19:40 PM UTC-4, Andrew A wrote: > > I am relatively new at using Sheets more advanced query features, and > though I have been learning it decently for the most part, I am having > trouble doing a few things. I have gotten a query that I think should do > what I want, but, obviously, it does not. The error message I got on this > attempt, though, seemed somewhat more specific, so I thought I should look > into what it means. > the message specifically is: "unable to parse query string for Function > QUERY parameter 2:CANNOT_GROUP_WITHOUT_AGG" > I can definitely give more details and context to make it easier for > people to help me with this if necessary. Broader help with this problem > would also be welcome, including help solving the issue overall. Of course, > my boss has also been on here asking for help accomplishing the overall > goal, before asking me to mess around with it to find some other > workarounds. This might not be the best use of my time, but I am an intern > and am paid primarily in coffee and snacks. > Also, just in case my boss comes across this, hi Frank! > -- 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/e40dfeac-92e5-449a-b045-305e9e6dbdee%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
