Stack Overflow
Stack Overflow

Questions tagged [google-query-language]

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source. This could also be used in the Google Sheets QUERY built-in function.

Google Query Language allow developers to perform various data manipulations using a syntax very similar to the SQL syntax. It's part of the and can be used in through the QUERY built-in function.

Before posting a question about the Google Query Language check the reference documentation.

1114 questions
-1
votes
1 answer

Importrange & query import order is random and not below each other

I have some problems, I am trying to resolve this now since a while but I am always ad a dead end. I have multiply taps in my DATA Sheet, each tap has 5000+ rows (in this example now way less), some rows have the same content and I want to find…
Guhlis
  • 91
  • 7
-1
votes
1 answer

How can I sum across multiple sheets using a named range with multiple conditions?

I believe what I am trying to do should be simple in Google Sheets formulae, but any solution based on an Excel formula should be easily transferable. Because additional characters will be added periodically, I have a named range:…
Aleister Tanek Javas Mraz
  • 452
  • 2
  • 8
  • 26
-1
votes
1 answer

Forming a Line of Row of Date from just Two Cells Information Google Sheet

I have list of assets There is information about buy date and buy value there is information about depreciation year I want to make the year of each deprecation and the depreciation value, be described yearly from top to down automatically I prefer…
Randy Adikara
  • 357
  • 3
  • 10
-1
votes
1 answer

How to extract top 5 sum values with their top 3 sum reasons?

I need to review this query: =QUERY('BD3'!A:Q, "SELECT D,Q, SUM(M) WHERE I='W34' AND M>0 AND L='Huacho' GROUP BY D,Q ORDER BY SUM(M) DESC LIMIT 5",-1) I obtain this: But I need something like this:
user16761351
  • 1
-1
votes
1 answer

How can I extract top 5 sums?

=QUERY('BD3'!A:Q, "SELECT L,D,I,SUM(M) WHERE I='W34' AND M>0 AND L='Huacho' GROUP BY L,D,I",-1) I need to just show the top 5 sums of column M.
user16760775
  • 3
  • 2
-1
votes
2 answers

How to compute the value based on criteria of other cells In Google Sheet Query?

In Google Sheet Query, how to compute the value based on criteria of other cells? Thanks.
user2988464
  • 3,251
  • 6
  • 21
  • 25
-1
votes
1 answer

Calculate Total row Averages correctly if table columns contain empty cells

I am using the following formula to calculate a Total row that calculates averages for percentages in the columns. However, since the data contains some empty values, the averages calculated is not…
sifar
  • 1,086
  • 1
  • 17
  • 43
-1
votes
2 answers

Find which users are working on the same JobID

I am pulling only the JobID column from each User Sheet in a Google spreadsheet. I want to query which Users are working on the same JobID. I need to also list the User's name as a Column of the query as that column is not present in each User…
sifar
  • 1,086
  • 1
  • 17
  • 43
-1
votes
1 answer

What is the query formula to compute unique values for each cell in a column including values from preceding rows in each date

For each row in Column C, i'm trying to computer the number of likes divided by the number of posts. For example in C2 cell from day one i divide 5 likes by 1 post, from day 2 i divide 7 likes by 1 post, then in day 3 i divide a sum of (8+1) likes…
Jcbyte
  • 207
  • 1
  • 4
  • 11
-1
votes
2 answers

google sheets, Make letters separated by comma given number of following columns. Not using app script, just formulas please

I'm using the query function in google sheets... I want to select columns F to AB. I need a cell that has the output F,G,H,I... ,AB so I can put it in the Select statement. This formula should have 2 inputs, the starting letter (F in this case) and…
jason
  • 3,811
  • 18
  • 92
  • 147
-1
votes
1 answer

Multiple "and"s using Google Query

I am trying to run multiple queries on a table using Google query. I have been trying to sparse the dataset using the a,b,c columns using multiple criteria for each column using an AND combiner. If one criterion is removed then I want the remaining…
Cameron Macleod
  • 1
  • 1
-1
votes
2 answers

Calculated field over list of values

Given this table of data: I'd like to produce this pivot table: I have an inkling this can be done with the calculated field, and SUMIF, but am not able to get it to work. I think the main blocker is that I'm not able to find good documentation…
dameshgarm
  • 1
  • 3
-1
votes
1 answer

How to transpose a table by pivoting one column?

Question - How could I manage to get the required output (see image below) from the given input? Is it possible without having to write a macro or a script? Background - Input is transactions from your banks, so there can be multiple transactions…
Greg
  • 34,042
  • 79
  • 253
  • 454
-1
votes
2 answers

Having trouble with the query formula for a report in Google Sheets

Here's the formula I have. Please evaluate and let me know if you see any issues. =(query(importrange("sheetLink","FormResponses"),"Select Col1, Col4, Col5 Where Col3 Contains '"&EmployeeName&"' And Col4 >= '"&ReportStartDate&"' And Col4 <=…
Ros Posey
  • 3
  • 2
-1
votes
1 answer

how to combine 2 textjoins with "AND" and "OR" statements in google docs query?

I have a query: =query(test_data_set!A2:C;"SELECT A, B, C" & if(countblank(dash!C1:C6)=6;"";" WHERE " & textjoin(" OR "; true; dash!C1:C4)) & "ORDER BY B";0) in C1:C4 there is a text in C5:C6 there is 2 dates so i need to add in query textjoin("…
Владимир Смирнов
  • 11
  • 1
1 2 3
…
74 75