{"id":275,"date":"2024-11-17T17:53:01","date_gmt":"2024-11-17T17:53:01","guid":{"rendered":"https:\/\/lookercourses.com\/?p=275"},"modified":"2025-10-09T19:27:03","modified_gmt":"2025-10-09T19:27:03","slug":"el-cuadro-de-entrada-y-el-filtro-avanzado-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/el-cuadro-de-entrada-y-el-filtro-avanzado-en-looker-studio\/","title":{"rendered":"El filtro avanzado y el cuadro de entrada en Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">El cuadro de entrada y el filtro avanzado son 2 controles de Looker Studio que funcionan m\u00e1s o menos como un buscados, y permiten al usuario final del informe filtrar los datos de los gr\u00e1ficos.<\/h3>\n\n\n\n<p>Para los ejemplos en este post, he utilizado el dataset de &#8216;<a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\">Productos Superstore<\/a>&#8216;. Para saber m\u00e1s sobre <a href=\"\/como-anadir-fuentes-de-datos-en-looker-studio\">c\u00f3mo a\u00f1adir fuentes de datos a tus informes<\/a>, puedes hacerlo en el post dedicado al tema.<\/p>\n\n\n\n<p>Visita el post sobre <a href=\"\/elementos-interactivos-en-looker-studio--los-controles\">c\u00f3mo a\u00f1adir controles en tus informes de Looker Studio<\/a>, si necesitas refrescarte la memoria.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cuadro de entrada<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfQu\u00e9 es?<\/h3>\n\n\n\n<p>\n  Es una caja donde el usuario puede escribir texto o n\u00fameros para buscar dentro de la dimensi\u00f3n del control y as\u00ed filtrar los gr\u00e1ficos existentes en la p\u00e1gina. Las condiciones disponibles son \u2018Igual a\u2019, \u2018Contiene\u2019, \u2018Empieza por\u2019, \u2018Regex\u2019 y \u2018En\u2019. Es importante mencionar que el texto introducido es sensible al uso de may\u00fasculas y min\u00fasculas.\n<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a id=\"post-275-_gbbu2u6rokos\"><\/a>\u00bfCu\u00e1ndo usarlo?<\/h3>\n\n\n\n<p>Cuando quieras que tus usuarios puedan filtrar por valores espec\u00edficos decididos por ellos mismos.<br><a id=\"post-275-_6vkjwn4m37ni\"><\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ejemplo<\/h3>\n\n\n\n<p>Sup\u00f3n que tienes una tabla con nombre de producto, cantidad e ingresos brutos y quieres ver todos aquellos que sean de la marca Wilson Jones. El nombre de producto contiene la marca, as\u00ed que puedes usar esa dimensi\u00f3n en tu control. Para a\u00f1adirla tienes que seleccionarla como <em>campo de control<\/em> en la configuraci\u00f3n del cuadro de entrada. En <em>Tipo de b\u00fasqueda<\/em> elige <em>Contiene<\/em>, ya que de este modo el usuario final podr\u00e1 filtrar por todos aquellos en los que las palabras Wilson Jones existan, independientemente de en qu\u00e9 posici\u00f3n est\u00e9n dentro del nombre.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"738\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-1.png\" alt=\"\" class=\"wp-image-276\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-1.png 470w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-1-191x300.png 191w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/figure>\n\n\n\n<p>El cuadro de entrada con la configuraci\u00f3n de arriba, deber\u00eda verse as\u00ed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"124\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-2.png\" alt=\"\" class=\"wp-image-277\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-2.png 414w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-2-300x90.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure>\n\n\n\n<p>\n  Recuerda que el texto introducido es sensible al uso de may\u00fasculas y min\u00fasculas.\n<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Filtro avanzado<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfQu\u00e9 es?<\/h3>\n\n\n\n<p>\n  Es igual que el cuadro de entrada pero las condiciones (\u2018Igual a\u2019, \u2018Contiene\u2019, \u2018Empieza por\u2019, \u2018Regex\u2019 y \u2018En\u2019) aparecen en la propia caja en forma de lista desplegable.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"119\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-3.png\" alt=\"\" class=\"wp-image-278\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-3.png 414w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-3-300x86.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfCu\u00e1ndo usarlo?<\/h3>\n\n\n\n<p>\n  Cuando adem\u00e1s de darle la opci\u00f3n al usuario de filtrar por un texto determinado por \u00e9l mismo, quieres que tambi\u00e9n elija la condici\u00f3n por la que filtrar ese texto. Se trata de un filtro m\u00e1s avanzado que el anterior.\n<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a id=\"post-275-_z2msf6bosyql\"><\/a>Ejemplo<\/h3>\n\n\n\n<p>\n  Podemos usar exactamente el mismo ejemplo que usamos para el cuadro de entrada. Yo personalmente prefiero usar el filtro avanzado para que el usuario tenga la opci\u00f3n de filtrar por la condici\u00f3n que m\u00e1s se ajuste a sus necesidades.\n<\/p>\n\n\n\n<p>\n  Si quieres cambiar la condici\u00f3n que aparece por defecto, puedes hacerlo dentro de <em>Tipo de b\u00fasqueda<\/em> en <em>Configuraci\u00f3n<\/em>.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"790\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-4.png\" alt=\"\" class=\"wp-image-279\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-4.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-275-4-180x300.png 180w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>\u00bfQu\u00e9 te han parecido estos 2 controles?, \u00bflos conoc\u00edas?<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>El cuadro de entrada y el filtro avanzado son 2 controles de Looker Studio que funcionan m\u00e1s o menos como [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1319,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[17],"tags":[4],"class_list":["post-275","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filtros-y-controles","tag-es"],"uagb_featured_image_src":{"full":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-entrada-y-el-filtro-avanzado-en-Looker-Studio.jpg",700,400,false]},"uagb_author_info":{"display_name":"barbmk","author_link":"https:\/\/lookercourses.com\/es\/author\/barbmk\/"},"uagb_comment_info":0,"uagb_excerpt":"El cuadro de entrada y el filtro avanzado son 2 controles de Looker Studio que funcionan m\u00e1s o menos como [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/comments?post=275"}],"version-history":[{"count":4,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/275\/revisions"}],"predecessor-version":[{"id":1991,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/275\/revisions\/1991"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1319"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}