How to Pivot with multiple WHERE AND and OR conditions with Query function in Google Sheets

Question

Goal: I want to create a pivot table with the QUERY function while using I have multiple criteria (using ANDs and ORs at the same time). The table basically consists of 2 columns: Col C is "Employee," Col B is "Status." The values for Status contains: "In Progress" "Consultation" "Require Information" and "Technical Issue." And there are multiple employee names that I won't bother listing. And I wanted it to basically count the number of statuses each employees have.

Now, I actually had a functional formula that was working well, however I wanted to add another criteria, which was to exclude (filter) one particular employee (let's say this person's name is "John A") from the result. And I want to be able to keep the criteria that I currently have and just add the new one. The formula before the modification is below.

Formula before modification:

=QUERY('Blend Data'!$A$3:$C,"select C, COUNT(C) where (B = 'In Progress' OR B = 'Consultation' OR B = 'Require Information' OR B = 'Technical Issue') GROUP BY C pivot B",0)

Issue: However I when I made changes to the formula, the result didn't change and didn't get any errors.

Formula after modification:

=QUERY('Blend Data'!$A$3:$C,"select C, COUNT(C) where (B = 'In Progress' OR B = 'Consultation' OR B = 'Require Information' OR B = 'Technical Issue' AND C = 'John A') GROUP BY C pivot B",0)

player0 · Accepted Answer · 2021-01-24 15:02:15Z

1

try:

=QUERY('Blend Data'!A3:C,
 "select C,count(C) 
  where B matches 'In Progress|Consultation|Require Information|Technical Issue' 
    and C = 'John A' 
  group by C 
  pivot B", 0)

answered Jan 24, 2021 at 15:02

player0

131k14 gold badges91 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

How to Pivot with multiple WHERE AND and OR conditions with Query function in Google Sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related