{"id":157,"date":"2024-10-27T21:09:42","date_gmt":"2024-10-27T21:09:42","guid":{"rendered":"https:\/\/lookercourses.com\/?p=157"},"modified":"2025-10-09T19:26:56","modified_gmt":"2025-10-09T19:26:56","slug":"las-tablas-dinamicas-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/las-tablas-dinamicas-en-looker-studio\/","title":{"rendered":"Las tablas din\u00e1micas en Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Al igual que las tablas, las din\u00e1micas sirven para visualizar datos de forma m\u00e1s detallada. Adem\u00e1s, estas tienen como ventaja que permiten analizar datos cruzando varias dimensiones simult\u00e1neamente. <\/h3>\n\n\n\n<p>En este post vamos a seguir utilizando el <a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\" data-type=\"post\" data-id=\"85\">dataset de top pel\u00edculas 2019<\/a>. <a id=\"post-157-_kotoq1p1tfbv\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Ejemplo<\/strong>\n<\/h2>\n\n\n\n<p>Imagina que quieres ver el n\u00famero de pel\u00edculas estrenadas por distribuidor y g\u00e9nero principal, teniendo el distribuidor en las filas y el g\u00e9nero en las columnas. Esto no es posible utilizando una tabla simple, ya que cada dimensi\u00f3n va a ser una columna distinta. Para poder cruzar tus dimensiones vi\u00e9ndo unas como filas y otras como columnas, tienes que usar tablas din\u00e1micas.<\/p>\n\n\n\n<p>A\u00f1ade una tabla din\u00e1mica y elige <em>Distribuidor<\/em> como<em> Dimensi\u00f3n de la fila<\/em>, <em>G\u00e9nero principal 1<\/em> como <em>Dimensi\u00f3n de la columna<\/em> y <em>Record count<\/em> como la m\u00e9trica. Puedes visitar el post sobre <a href=\"\/como-anadir-visualizaciones-a-un-informe-de-looker-studio\">c\u00f3mo a\u00f1adir visualizaciones en Looker Studio<\/a> si necesitas refrescarte la memoria.<\/p>\n\n\n\n<p class=\"has-text-align-center\">\n  &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\n<\/p>\n\n\n\n<p class=\"has-text-align-center\">\n  Record count hace recuento del n\u00famero de filas. Como tenemos una pel\u00edcula por fila, en este caso es lo mismo que el n\u00famero de pel\u00edculas.\n<\/p>\n\n\n\n<p class=\"has-text-align-center\">\n  &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"1252\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-2.png\" alt=\"\" class=\"wp-image-159\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-2.png 480w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-2-115x300.png 115w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-2-393x1024.png 393w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1294\" height=\"586\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-3.png\" alt=\"\" class=\"wp-image-160\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-3.png 1294w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-3-300x136.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-3-1024x464.png 1024w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-3-768x348.png 768w\" sizes=\"auto, (max-width: 1294px) 100vw, 1294px\" \/><\/figure>\n\n\n\n<p>\n  Aqu\u00ed puedes ver que Universal Pictures estren\u00f3 el mayor n\u00famero de pel\u00edculas (14) entre las top de m\u00e1s ingresos, siendo sus top g\u00e9neros animaci\u00f3n (3 pel\u00edculas) y comedia (tambi\u00e9n 3). Sony Pictures Releasing est\u00e1 en segundo lugar con 11 pel\u00edculas, de las cuales 2 fueron de acci\u00f3n, y 2 de comedia, entre otros g\u00e9neros.\n<\/p>\n\n\n\n<p><br>Si hubieras elegido una tabla simple, las dimensiones de distribuidor y g\u00e9nero aparecer\u00edan ambas en columnas, pero con la din\u00e1mica una se muestra en filas y la otra en columnas.<br><a id=\"post-157-_m63shwcr4r8c\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/strong><\/h2>\n\n\n\n<p>\n  Dentro de Configuraci\u00f3n puedes activar <em>Mostrar la suma total<\/em> de las filas y de las columnas para que se muestra una fila y una columna con los totales.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"520\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-4.png\" alt=\"\" class=\"wp-image-161\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-4.png 478w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-4-276x300.png 276w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"433\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-5.png\" alt=\"\" class=\"wp-image-162\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-5.png 941w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-5-300x138.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-5-768x353.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<p>\n  Adem\u00e1s, puedes elegir qu\u00e9 campo determinar\u00e1 el orden tanto de la primera fila como de la primera columna.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"980\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-6.png\" alt=\"\" class=\"wp-image-163\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-6.png 478w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-6-146x300.png 146w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<p>\n  Al igual que las tablas simples, las din\u00e1micas permiten representar las m\u00e9tricas con barras y mapas de calor. Esto puedes configurarlo dentro de <em>Estilo<\/em> yendo a la columna de la m\u00e9trica en cuesti\u00f3n. En este caso vamos a elegir representarla con barras y a seleccionar<em> Mostrar n\u00famero<\/em>, porque sino aparecen las barras sin el n\u00famero.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"622\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-7.png\" alt=\"\" class=\"wp-image-164\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-7.png 478w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-7-231x300.png 231w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"444\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-8.png\" alt=\"\" class=\"wp-image-165\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-8.png 941w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-8-300x142.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-8-768x362.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<p>\n  Para ver las columnas con barras, en lugar de seguir el paso anterior, puedes elegir directamente el gr\u00e1fico llamado <em>Tabla din\u00e1mica con barras<\/em>. O si quieres verlas como mapa de calor, puedes seleccionar el llamado <em>Tabla din\u00e1mica con mapa de calor<\/em>.\n<\/p>\n\n\n\n<p>Dentro de <em>Estilo<\/em> puedes dar formato condicional a tus celdas, donde mostrar\u00e1n un color u otro dependiendo del valor de la m\u00e9trica. Puedes hacerlo d\u00e1ndole a <em>A\u00f1adir<\/em> debajo de <em>Formato condicional<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"412\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-9.png\" alt=\"\" class=\"wp-image-166\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-9.png 480w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-9-300x258.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<p>Por ejemplo, si quieres que se pinten de verde aquellas celdas que tengas un 3 o m\u00e1s, tienes que hacerlo de la siguiente manera.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"504\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-10.png\" alt=\"\" class=\"wp-image-167\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-10.png 939w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-10-300x161.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-10-768x412.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p>Y la regla de formato condicional por la que aquellas celdas con 3 o m\u00e1s pel\u00edculas se aplicar\u00e1 a tu tabla din\u00e1mica y dichas celdas se pintar\u00e1n de verde.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"441\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-11.png\" alt=\"\" class=\"wp-image-168\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-11.png 941w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-11-300x141.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-157-11-768x360.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<p>El formato condicional est\u00e1 tambi\u00e9n disponible en otros gr\u00e1ficos, no es espec\u00edfico de las tablas din\u00e1micas. Para ver si est\u00e1 o no disponible para una visualizaci\u00f3n en cuesti\u00f3n, tienes que ir a la columna <em>Estilo<\/em> del propio gr\u00e1fico. Si aparece <em>Formato condicional<\/em> arriba del todo, entonces es que est\u00e1 disponible.<\/p>\n\n\n\n<p>\u00bfQu\u00e9 te han parecido las opciones disponibles para tablas din\u00e1micas en Looker Studio? \u00bfSueles utilizarlas?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Al igual que las tablas, las din\u00e1micas sirven para visualizar datos de forma m\u00e1s detallada. Adem\u00e1s, estas tienen como ventaja [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1348,"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":[9],"tags":[4],"class_list":["post-157","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-graficos","tag-es"],"uagb_featured_image_src":{"full":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-tablas-dinamicas-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":"Al igual que las tablas, las din\u00e1micas sirven para visualizar datos de forma m\u00e1s detallada. Adem\u00e1s, estas tienen como ventaja [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/157","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=157"}],"version-history":[{"count":1,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":1227,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/157\/revisions\/1227"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1348"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}