Google Sheet Query Error: Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC

Question

I am getting this error message on my query formula

"Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC"

and I don't know what seems to be the problem. I already change the format of column C to percentage but I'm still getting the same error.

=Query('Sheet1'!A1:C, "select A, avg(C), count(C) group by A,C", 1)

Sample Data:

 Date      | Name | CSAT %|
-----------|------|-------|
 2017-10-22| asdf |   100%|
 2017-10-15| qwer |   50% |
 2017-10-08| zxcv |   75% |
 2017-10-01| qwer |   90% |

Here is the actual file that I'm working on. docs.google.com/spreadsheets/d/… — Zyre Soriano
– Zyre Soriano, Commented Nov 3, 2017 at 12:13

Codebling · Accepted Answer · 2019-03-17 06:53:38Z

1

One column of numerical data in my sheet would not register as numbers, no matter what (you can test this with function N(). It will show 0 for data which isn't considered numerical).

I fixed this with an extra column which added 0 to my numerical column. Even though the original column wasn't considered numerical, this somehow worked.

answered Mar 17, 2019 at 6:53

Codebling

11.5k3 gold badges45 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael come lately · Accepted Answer · 2017-11-13 15:37:48Z

-5

I finally solved the puzzle using this:

=arrayformula(query({'Sheet1'!A:N, arrayformula(if(ISBLANK('Sheet1'!O:O), -1, value('Sheet1'!O:O)))

Basically, I put -1 on blank spaces in between rows and then on my query, I placed a condition to include only rows that have a value of >=0.

edited Nov 13, 2017 at 15:37

Michael come lately

9,6418 gold badges70 silver badges97 bronze badges

answered Nov 6, 2017 at 11:43

Zyre Soriano

6136 gold badges14 silver badges27 bronze badges

3 Comments

Rumbles Over a year ago

You have an open curly brace in your answer, but no close, so how would that ever work?

Zyre Soriano Over a year ago

This was just part of the entire formula that's why it isn't complete.

Veggiet Over a year ago

In order to be of help to others it would be great if you would include the entire formula, I'm struggling with a similar problem.

Collectives™ on Stack Overflow

Google Sheet Query Error: Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related