{"id":2081,"date":"2018-11-28T17:22:44","date_gmt":"2018-11-28T17:22:44","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=2081"},"modified":"2023-05-03T20:08:26","modified_gmt":"2023-05-03T20:08:26","slug":"la-formula-query-en-google-sheets","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/","title":{"rendered":"La f\u00f3rmula QUERY en Google Sheets"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p><script>(function(d, s, id) {<br \/>\n  var js, fjs = d.getElementsByTagName(s)[0];<br \/>\n  if (d.getElementById(id)) return;<br \/>\n  js = d.createElement(s); js.id = id;<br \/>\n  js.src = 'https:\/\/connect.facebook.net\/es_LA\/sdk.js#xfbml=1&version=v3.2&appId=693778360782739&autoLogAppEvents=1';<br \/>\n  fjs.parentNode.insertBefore(js, fjs);<br \/>\n}(document, 'script', 'facebook-jssdk'));<\/script><\/p>\n<h1>Acerca de la f\u00f3rmula QUERY.<\/h1>\n<div class=\"fb-share-button\" data-href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\" data-layout=\"box_count\" data-size=\"large\" data-mobile-iframe=\"true\"><a class=\"fb-xfbml-parse-ignore\" href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=http%3A%2F%2Fwww.fditf.com%2Fbi%2Fgoogle-sheets%2Fla-formula-query-en-google-sheets%2F&amp;src=sdkpreparse\" target=\"_blank\" rel=\"noopener noreferrer\">Compartir<\/a><\/div>\n<p>Esta es una f\u00f3rmula exclusiva de Google Sheets (no la encontrar\u00e1s en Microsoft Excel), y es asombrosa, ya que permite realizar <em>queries (consultas)<\/em> en una hoja de c\u00e1lculo (<em><span class=\"items\"><span class=\"item\">google spreadsheet<\/span><\/span><\/em>) usando sentencias en SQL, como si tu hoja de c\u00e1lculo fuera una base de datos. Tambi\u00e9n es un buen punto de partida para familiarizase con el lenguaje SQL, pues usa una estructura b\u00e1sica. Y hasta puede convertirse en un buen sustituto de una tabla din\u00e1mica.<\/p>\n<p>Para poder crear los ejemplos, estoy usando datos del CENACE (Centro Nacional de Control de Energ\u00eda): precios de nodos distribuidos (<span style=\"color: #0000ff;\"><em>https:\/\/datos.gob.mx\/busca\/dataset\/precios-de-nodos-distribuidos\/resource\/0adafacb-2229-46e5-9755-2c2ed865a401<\/em><\/span>). En el archivo de trabajo hay dos p\u00e1ginas b\u00e1sicas: i) raw_data y ii) data. La primera muestra los datos tal cual fueron descargados. La segunda muestra los datos con unos cuantos cambios en el formato y la separaci\u00f3n de la fecha en d\u00eda, mes y a\u00f1o. Consulta aqu\u00ed el libro de trabajo, y sigue los ejemplos para que puedas conocer el potencial de esta f\u00f3rmula:&nbsp;<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/12u9_ao-w3dBJwNlekcXvfm_Ei7vw0ydVJxGkzDNOSLI\/edit#gid=1195793894\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/12u9_ao-w3dBJwNlekcXvfm_Ei7vw0ydVJxGkzDNOSLI\/edit#gid=1195793894.<\/a><\/p>\n<p>La f\u00f3rmula requiere dos argumentos: datos y query. Y as\u00ed est\u00e1n estructurados todos los ejemplos.<br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4298448911\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>Ejemplo 0. Extraer todos los datos.<\/h2>\n<p>Con este <em>query<\/em>, tomar\u00e1s todos los datos del origen, y ser\u00e1n llevado al lugar donde has puesto la f\u00f3rmula. En este caso, los datos est\u00e1n en la hoja &#8220;data&#8221;, y con esta f\u00f3rmula los estamos llevando a la hoja &#8220;ejemplo0&#8221;, con origen en la celda A1. La f\u00f3rmula queda as\u00ed:<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\" style=\"color: #339966;\">&#8220;SELECT *&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<ul>\n<li>Notar\u00e1s que todos los datos de la hoja de origen fueron llevados a la hoja de destino.<\/li>\n<li>La sentencia <span style=\"color: #339966;\"><strong>&#8220;SELECT *&#8221;<\/strong><\/span> indica que se deben seleccionar todo los datos de origen.<\/li>\n<li>Compru\u00e9balo aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/10SNRhzo4fS7iJGYxAMoy8rhKXFQjLNlaiLS1Uf82l7c\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2094\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query0.png\" alt=\"\" width=\"483\" height=\"348\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query0.png 483w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query0-300x216.png 300w\" sizes=\"auto, (max-width: 483px) 100vw, 483px\" \/><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.datacamp.com?tap_a=82040-4385c0&amp;tap_s=984551-40cf2c\" target=\"_BLANK\" rel=\"nofollow noopener noreferrer\"><img decoding=\"async\" src=\"https:\/\/static.tapfiliate.com\/5f922766d7ec0196634518.png?a=82040-4385c0&amp;s=984551-40cf2c\" alt=\"Conoce Datacamp!\" border=\"0\"><\/a><\/p>\n<h2>Ejemplo 1. Extraer las primeras tres columnas.<\/h2>\n<p>Con este <em>query<\/em>, tomar\u00e1s las primeras tes columnas de los datos del origen, y ser\u00e1n llevado al lugar donde has puesto la f\u00f3rmula. En este caso, los datos est\u00e1n en la hoja &#8220;data&#8221;, y con esta f\u00f3rmula los estamos llevando a la hoja &#8220;ejemplo1&#8221;, con origen en la celda A1. La f\u00f3rmula queda as\u00ed:<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\" style=\"color: #339966;\">&#8220;SELECT A, B, C&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Notar\u00e1s que todos los datos de la hoja de origen fueron llevados a la hoja de destino. Compru\u00e9balo aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1yGNRQs0E7cCcluL0CNU4InMGwYqAtMihOqh5qmxxaHA\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2096\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query1.png\" alt=\"\" width=\"489\" height=\"347\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query1.png 489w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query1-300x213.png 300w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><br \/>\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7518930939\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>Ejemplo 2. Extraer todas las columnas donde la &#8220;zona de carga&#8221; es &#8220;ACAPULCO&#8221;<\/h2>\n<p>Empezamos con los filtros. Para facilitar las cosas, incluiremos todas las columnas (&#8220;select *&#8221;), y agregaremos a continuaci\u00f3n un filtro a la columna F para encontrar los valores correspondientes a ACAPULCO (&#8220;where F = &#8216;ACAPULCO'&#8221;). \u00a1No olvides las comillas!:<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT * WHERE F = &#8216;ACAPULCO'&#8221;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1873uRHUoOffO9TJZsLz3WXo40xA0evCWlremBhv1vJ4\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2097\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query2.png\" alt=\"\" width=\"495\" height=\"350\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query2.png 495w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query2-300x212.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/p>\n<h2>Ejemplo 3. Extraer todas las columnas donde la &#8220;zona de carga&#8221; es &#8220;ACAPULCO&#8221; Y &#8220;ZACAPU&#8221;<\/h2>\n<p>La f\u00f3rmula es pr\u00e1cticamente la misma, pero agregaremos un operador (OR) al filtro para obtener los resultados coincidentes con el requerimiento:<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT * WHERE (F = &#8216;ACAPULCO&#8217; OR F = &#8216;ZACAPU&#8217;)&#8221;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1m8yP122KpKS6pNMBzZAUXEPRQGYvN8q_Q1p4ZsYI0Ws\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"5242072910\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2098\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query3.png\" alt=\"\" width=\"670\" height=\"304\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query3.png 670w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query3-300x136.png 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/p>\n<h2>Ejemplo 4. Extraer todas las columnas donde la &#8220;zona de carga&#8221; es &#8220;ACAPULCO&#8221; Y &#8220;ZACAPU&#8221;, y donde la hora sea menor o igual a 12.<\/h2>\n<p>Ahora tenemos un filtro combinado (aplicado a dos atributos\/columnas). El primero filtro est\u00e1 aplicado a la columna F (zona de carga); y agregaremos un filtro aplicado a la hora (columna E):<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT * WHERE (F = &#8216;ACAPULCO&#8217; OR F = &#8216;ZACAPU&#8217;) AND (E &lt;= 12)&#8221;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/149UwcdunS_oUwCmZuWVcN7vNbMtsoiPqHF7xhBbGw6A\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2100\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query4.png\" alt=\"\" width=\"803\" height=\"300\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query4.png 803w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query4-300x112.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query4-768x287.png 768w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/p>\n<h2>Ejemplo 5. Extraer zona de carga, hora, precio zonal y fecha, donde la &#8220;zona de carga&#8221; es &#8220;ACAPULCO&#8221;.<\/h2>\n<p>Con este <em>query<\/em> vamos a extraer solamente algunas columnas, en el orden en que las necesitamos, y aqu\u00ed tambi\u00e9n estamos usando filtro (con el comando WHERE):<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT F, E, G, A WHERE (F = &#8216;ACAPULCO&#8217;)&#8221;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1EDcjvLGaagcWU-KkTXgJIQEVtost14yEiHQZDXgupkw\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<br \/>\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- googleQuery_opt2 --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4325242641\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2101\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query5.png\" alt=\"\" width=\"616\" height=\"324\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query5.png 616w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query5-300x158.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/p>\n<h2>Ejemplo 6. Extraer zona de carga, hora y&nbsp;<span style=\"color: #ff0000;\">precio promedio por hora<\/span>, donde la &#8220;zona de carga&#8221; es &#8220;ACAPULCO&#8221;.<\/h2>\n<p>Con este <em>query<\/em> vamos a extraer solamente algunas columnas, en el orden en que las necesitamos, y aqu\u00ed tambi\u00e9n estamos usando filtro (con el comando WHERE). Adem\u00e1s de lo anterior, haremos una operaci\u00f3n matem\u00e1tica con el precio, calculando el promedio por hora (<strong><span class=\" default-formula-text-color\" dir=\"auto\"><span style=\"color: #339966;\"><span style=\"color: #0000ff;\">avg(G)<\/span><\/span><\/span><\/strong>). Es posible hacer operaciones de suma y promedio, pero siempre debes indicar c\u00f3mo est\u00e1n agrupados los datos. En este bloque, se trata de los precios de la zona de carga &#8220;Acapulco&#8221; (columna F), y queremos un promedio por hora (columna E).<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT F, E, <span style=\"color: #0000ff;\">avg(G)<\/span> WHERE (F = &#8216;ACAPULCO&#8217;) <span style=\"color: #ff0000;\">GROUP BY F, E<\/span>&#8220;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>En autom\u00e1tico, la f\u00f3rmula cambia el encabezado de la tercera columna (donde calculamos el promedio), indicando que se trata del promedio del precio zonal: &#8220;avg Precio Zonal ($\/MWh)&#8221;.<\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1My5tcASTEFDdmHYNf_RrKKISIABs15jcst6ZaL-4ODc\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2104\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query6.png\" alt=\"\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query6.png 742w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query6-300x150.png 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>Ejemplo 7. Extraer zona de carga, hora y&nbsp;<span style=\"color: #ff0000;\">precio promedio por hora<\/span>, donde la &#8220;zona de carga&#8221; es &#8220;ACAPULCO&#8221;. Al final, cambiar nombres de las columnas.<\/h2>\n<p>Ahora cambiaremos los encabezados del <em>query. <\/em>Usaremos el comando LABEL, seguido de la indicaci\u00f3n de la columna y el nombre que necesitamos. Por ejemplo, la columna F ahora se llamar\u00e1 &#8220;ZONA&#8221;, la columna E ahora se llamar\u00e1 &#8220;HORA&#8221; (con may\u00fasculas).<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT F, E, <span style=\"color: #0000ff;\">avg(G)<\/span> WHERE (F = &#8216;ACAPULCO&#8217;) <span style=\"color: #ff0000;\">GROUP BY F, E <span style=\"color: #00ccff;\">LABEL F &#8216;ZONA&#8217;, E &#8216;HORA&#8217;, avg(G) &#8216;PRECIO PROMEDIO&#8217;<\/span><\/span>&#8220;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1xo3INdhiv5LZdNtf6VK_5xDN7JOCbH1pIFDys1qZ_kI\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2108\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query7.png\" alt=\"\" width=\"1180\" height=\"333\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query7.png 1180w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query7-300x85.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query7-768x217.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query7-1024x289.png 1024w\" sizes=\"auto, (max-width: 1180px) 100vw, 1180px\" \/><\/p>\n<h2><span style=\"color: #000000;\">Ejemplo 8. Extraer zona de carga, hora y&nbsp;precio promedio por hora para todas las zonas de carga. Mostrar una columna por cada hora.<\/span><\/h2>\n<p>Otra de las maravillas de esta f\u00f3rmula es el comando PIVOT. A partir de un conjunto de datos, el comando pivot despliega y recalcula la informaci\u00f3n en columnas a partir de un campo de referencia (que se usa como pivote). En este caso, usaremos el campo &#8220;HORA&#8221; como pivote. El primer c\u00e1lculo es el promedio por zona, y al agregar el comando PIVOT, los datos se recalculan mostrando el promedio por hora.<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT F, avg(G) GROUP BY F <span style=\"color: #ff0000;\">PIVOT E<\/span> LABEL F &#8216;ZONA'&#8221;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/18udb3K684UyiWK5SRP8lBD6IM5u4xHQLQDnEOQK0Gcw\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2111\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png\" alt=\"\" width=\"695\" height=\"415\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png 695w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8-300x179.png 300w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.datacamp.com?tap_a=82040-4385c0&amp;tap_s=984551-40cf2c\" target=\"_BLANK\" rel=\"nofollow noopener noreferrer\"><img decoding=\"async\" src=\"https:\/\/static.tapfiliate.com\/5f922766d7ec0196634518.png?a=82040-4385c0&amp;s=984551-40cf2c\" alt=\"Conoce Datacamp!\" border=\"0\"><\/a><\/p>\n<h2><span style=\"color: #000000;\">Ejemplo 9. Extraer zona de carga, hora y&nbsp;precio promedio por hora para todas las zonas de carga y por semana. Mostrar una columna por cada hora.<\/span><\/h2>\n<p>Para mostrar los datos por semana, agregamos el n\u00famero de semana usando WEEKNUM en la columna K. Y reagrupamos los datos en la f\u00f3rmula (agregando el n\u00famero de semana):<\/p>\n<p style=\"text-align: center;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\" style=\"color: #ff6600;\">data!A:J<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<span style=\"color: #339966;\">&#8220;SELECT F, K, avg(G) GROUP BY F, K PIVOT E LABEL F &#8216;ZONA&#8217;, K &#8216;SEMANA'&#8221;<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/p>\n<p>Como lo puedes notar, puedes agrupar por m\u00faltiples columnas (aqu\u00ed lo hicimos por zona y semana), y adem\u00e1s desplegar c\u00e1lculos basados en otro campo (en este caso, por hora). Comprueba el resultado aqu\u00ed: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1MaE9z6FksWFT091QJPSfQ-UF8jv4Yrr1toEBOCu7Srk\/edit#gid=1324893745\" target=\"_blank\" rel=\"noopener noreferrer\">ver archivo<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2113\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query9.png\" alt=\"\" width=\"843\" height=\"327\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query9.png 843w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query9-300x116.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query9-768x298.png 768w\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" \/><\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- MainMenu --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: inline-block; width: 300px; height: 600px;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"9353874363\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<p>Conoce el potencial de toda la suite de Google, obt\u00e9n una prueba gratuita de la suite; m\u00e1s informaci\u00f3n en este enlace (Google): <a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/goo.gl\/ZPXKU2<\/a><\/p>\n<p><a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-267 size-medium\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/google-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\"><\/a><\/p>\n<div class=\"fb-share-button\" data-href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\" data-layout=\"box_count\" data-size=\"large\" data-mobile-iframe=\"true\"><a class=\"fb-xfbml-parse-ignore\" href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=http%3A%2F%2Fwww.fditf.com%2Fbi%2Fgoogle-sheets%2Fla-formula-query-en-google-sheets%2F&amp;src=sdkpreparse\" target=\"_blank\" rel=\"noopener noreferrer\">Compartir<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Acerca de la f\u00f3rmula QUERY. Compartir Esta es una f\u00f3rmula exclusiva de Google Sheets (no la encontrar\u00e1s en Microsoft Excel), y es asombrosa, ya que permite realizar queries (consultas) en una hoja de c\u00e1lculo (google spreadsheet) usando sentencias en SQL, <a href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":2111,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,249],"tags":[219],"class_list":["post-2081","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets","category-top-posts","tag-query"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>La f\u00f3rmula QUERY en Google Sheets - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"Ejemplos de la f\u00f3rmula query en google sheets (googlesheets, google spreadsheet), query google sheets, funci\u00f3n query google sheets\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"F\u00f3rmula QUERY en Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Consulta los ejemplos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-28T17:22:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-03T20:08:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/QUERY_FORMULA.png\" \/>\n\t<meta property=\"og:image:width\" content=\"602\" \/>\n\t<meta property=\"og:image:height\" content=\"347\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"F\u00f3rmula QUERY en Google Sheets\" \/>\n<meta name=\"twitter:description\" content=\"Consulta los ejemplos.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/QUERY_FORMULA.png\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"La f\u00f3rmula QUERY en Google Sheets\",\"datePublished\":\"2018-11-28T17:22:44+00:00\",\"dateModified\":\"2023-05-03T20:08:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\"},\"wordCount\":1220,\"publisher\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png\",\"keywords\":[\"QUERY\"],\"articleSection\":[\"Google Sheets\",\"Top posts\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\",\"url\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\",\"name\":\"La f\u00f3rmula QUERY en Google Sheets - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png\",\"datePublished\":\"2018-11-28T17:22:44+00:00\",\"dateModified\":\"2023-05-03T20:08:26+00:00\",\"description\":\"Ejemplos de la f\u00f3rmula query en google sheets (googlesheets, google spreadsheet), query google sheets, funci\u00f3n query google sheets\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage\",\"url\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png\",\"contentUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png\",\"width\":695,\"height\":415},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fditf.com\/bi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"La f\u00f3rmula QUERY en Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#website\",\"url\":\"https:\/\/www.fditf.com\/bi\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fditf.com\/bi\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\/\/www.fditf.com\/bi\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png\",\"contentUrl\":\"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\",\"https:\/\/x.com\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\/\/www.fditf.com\/bi\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"La f\u00f3rmula QUERY en Google Sheets - Business Intelligence MX","description":"Ejemplos de la f\u00f3rmula query en google sheets (googlesheets, google spreadsheet), query google sheets, funci\u00f3n query google sheets","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"F\u00f3rmula QUERY en Google Sheets","og_description":"Consulta los ejemplos.","og_url":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-11-28T17:22:44+00:00","article_modified_time":"2023-05-03T20:08:26+00:00","og_image":[{"width":602,"height":347,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/QUERY_FORMULA.png","type":"image\/png"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_title":"F\u00f3rmula QUERY en Google Sheets","twitter_description":"Consulta los ejemplos.","twitter_image":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/QUERY_FORMULA.png","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"La f\u00f3rmula QUERY en Google Sheets","datePublished":"2018-11-28T17:22:44+00:00","dateModified":"2023-05-03T20:08:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/"},"wordCount":1220,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png","keywords":["QUERY"],"articleSection":["Google Sheets","Top posts"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/","url":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/","name":"La f\u00f3rmula QUERY en Google Sheets - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png","datePublished":"2018-11-28T17:22:44+00:00","dateModified":"2023-05-03T20:08:26+00:00","description":"Ejemplos de la f\u00f3rmula query en google sheets (googlesheets, google spreadsheet), query google sheets, funci\u00f3n query google sheets","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/query8.png","width":695,"height":415},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"La f\u00f3rmula QUERY en Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=2081"}],"version-history":[{"count":40,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2081\/revisions"}],"predecessor-version":[{"id":18520,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2081\/revisions\/18520"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/2111"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=2081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=2081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=2081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}