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
0
votes
1 answer

Query command in google spreadsheet

my question isn't exactly about programming but I need help with google spreadsheets. So my problem is visible here: https://docs.google.com/spreadsheets/d/1OP_ottKUgSWOoU4hNSYz6X3dN67Z4KiALN0spWm9KoI/edit?usp=sharing I am a teacher and I have a…
0
votes
1 answer

Get unique values in a range where each value depends on the other cell

Here is an example table columns A,B,C where A - post time, B - name of a team, D - chosen date 10.08.2014 10:21:22, Name1, 25Mar 10.08.2014 10:21:23, Name1, 25Mar 10.08.2014 10:21:24, Name2, 28Mar 10.08.2014 10:21:25, Name2, 28Mar 10.08.2014…
alexsuslin
  • 4,130
  • 1
  • 20
  • 30
0
votes
1 answer

Google Spreadsheets Query not reacting as expected

I'm following the reference for GQL here: https://developers.google.com/chart/interactive/docs/querylanguage What I was trying to do is select a name from col A, if a value is set in col C, based on the highest value in col H, limited to 1…
0
votes
1 answer

Google fusiontables sql OR clause

I m trying the sample at https://developers.google.com/fusiontables/docs/samples/gviz_datatable In the query, instead of query += " WHERE 'Scoring Team' = '" + team + "'"; i tried to add another OR condition... query += " WHERE 'Scoring Team' = '"…
0
votes
1 answer

Unable to update a column value in Python on Google App engine

I am able to fetch a row from a db model with condition and but unable to update a particular column in that row: My DB model is as follow: class UserDB(db.Model): userNickName = db.StringProperty() userEmailID = db.StringProperty() …
krishna Prasad
  • 3,541
  • 1
  • 34
  • 44
0
votes
1 answer

Google Visualization Query - Abort Request

I am working on an interface that contains several high-intensity SQL queries, then renders multiple Google charts which are currently being called via AJAX using the google.visualization.Query object: var query = new…
0
votes
1 answer

Google Spreadsheet, Query Date older than 5 years ago

I am trying to query a count of machines that are older than 5 years. My machine data is in one tab with date time stamps in column K like "8/8/2008 8:08:08" I have tried many different variations to get the query right... but my latest is like…
-1
votes
1 answer

Google sheets QUERY with reference to another cell with number

I want to query a column based on the value of a cell I am referencing in the formula. partial screenshot of sheet I'd expect the formula in F3 to retrieve all values of column D below the value defined in F6. Instead I get a #VALUE! error. Is…
-1
votes
1 answer

Google sheets get empty cells next to each other

Link: https://docs.google.com/spreadsheets/d/1hCG6jjGSGWMn5kBkDfcoTJkZ2eCC5SRvHWMFTBp_6OE/edit?usp=sharing I want to return "Yes" or "No" results in column N when there are empty cells next to each other in the range B:M And column O counts the…
-1
votes
2 answers

Convert datetime from UTC to IST in google sheet using query funtion

I have the column shown in the figure I just want to convert the datetime column from UTC to IST I am trying to add 05:30:00 to each row using google query_language but couldn't find a way Please help me enter image description here
-1
votes
1 answer

Google Sheets Query With Multiple IF Statements

I am trying to run a some nested IF statements with a query (with an import range to another sheet). Such that, if cell B2 is 'ABC', it will query the ABC sheet and return the value of a cell on that sheet. Same for the other two sheets, 'XYZ' and…
-1
votes
1 answer

Wrong sorting while using Query function

I've been trying to do a report about the quantity of breakdonws of products in our company. The problem is that the QUERY function is operating as normal, but the sorting order is well - a bit strange. The data I'm trying to sort are as follows…
-1
votes
1 answer

Google Sheets: Chart counting combinations

In the following Google spreadsheet Description No. of participants Severity Problem 1 2 Minor Problem 2 2 Major Problem 3 1 Minor Problem 4 1 Minor Problem 5 2 Major I would like to create a chart that has the No. of…
Yahalnaut
  • 157
  • 1
  • 8
-1
votes
1 answer

Compare two lists and print what is missing

I have two tables In list TEST22, which fruits did the buyer buy! https://docs.google.com/spreadsheets/d/1wOZWSPapMTnLGco4POGjsO2nKPdCNIiD_TCsfFjegPs/edit?usp=sharing In the TETS2 sheet, I want to select a buyer and display which puffs he did not…
-1
votes
1 answer

I need to get the answer that is 1 above my query search

I have an equation that goes into a column and searches for the first 0, the column tracks the progress of things in 1s and 0s, problem is that setting it to find 1 only returns the top most value, I would either need this to find the and return the…
Sondre
  • 7
  • 2