{"id":374,"date":"2024-12-01T14:23:13","date_gmt":"2024-12-01T14:23:13","guid":{"rendered":"https:\/\/lookercourses.com\/?p=374"},"modified":"2025-10-09T19:27:11","modified_gmt":"2025-10-09T19:27:11","slug":"el-diagrama-de-sankey-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/el-diagrama-de-sankey-en-looker-studio\/","title":{"rendered":"El diagrama de Sankey en Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">El diagrama de Sankey muestra c\u00f3mo se distribuye y fluye una dimensi\u00f3n, trazando m\u00faltiples caminos en direcci\u00f3n a los que se mueven los datos. El grosor de esos enlaces representa el peso que tiene la relaci\u00f3n en base a la m\u00e9trica de peso elegida.<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">En este post vamos a ver un ejemplo usando el diagrama de Sankey y vamos a explorar qu\u00e9 opciones de configuraci\u00f3n tiene.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Recuerda que si necesitas refrescarte la memoria sobre <a href=\"\/como-anadir-fuentes-de-datos-en-looker-studio\">c\u00f3mo a\u00f1adir visualizaciones a tu informe de Looker Studio<\/a>, puedes hacerlo en el post sobre ello.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplo<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Vamos a usar los datos que utilizamos en <a href=\"https:\/\/lookercourses.com\/es\/category\/looker-studio\/mapas\/\">los posts sobre mapas<\/a>, los de <a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\">las tiendas de H&amp;M<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En este ejemplo quiero mostrar c\u00f3mo visualizar la relaci\u00f3n entre continentes y ciudades con mayor n\u00famero de tiendas de H&amp;M. Como dimensiones elige <em>Continente<\/em> y <em>Pa\u00eds<\/em> y como m\u00e9trica <em>Record count<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"922\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-2.png\" alt=\"\" class=\"wp-image-376\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-2.png 610w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-2-198x300.png 198w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Este es el diagrama de Sankey resultante con continente y pa\u00eds como dimensiones, y el n\u00famero de tiendas (Record count) como m\u00e9trica de peso<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"677\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-3.png\" alt=\"\" class=\"wp-image-377\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-3.png 827w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-3-300x246.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-3-768x629.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"post-374-_4yn0ecktcz3e\"><\/a>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">El l\u00edmite de filas del diagrama es de 500 por defecto. B\u00e1jalo a 20 para que las relaciones se vean m\u00e1s claras. Lo que har\u00e1 es mostrar los 20 pa\u00edses con m\u00e1s tiendas, es decir, los valores en mi dimensi\u00f3n de destino con m\u00e1s peso en la m\u00e9trica elegida.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"402\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-4.png\" alt=\"\" class=\"wp-image-378\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-4.png 610w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-4-300x198.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Aqu\u00ed est\u00e1 nuestro diagrama de Sankey de 20 filas con continente y pa\u00eds como dimensiones, y el n\u00famero de tiendas (Record count) como m\u00e9trica de peso.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"644\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-5.png\" alt=\"\" class=\"wp-image-379\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-5.png 826w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-5-300x234.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-5-768x599.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">El grosor del enlace que une el nombre del continente con el pa\u00eds determina el valor de la m\u00e9trica (<em>Record count)<\/em>. Ver\u00e1s que Europa tiene mayor n\u00famero de tiendas que Norte Am\u00e9rica, pero si lo miras por ciudad, el enlace m\u00e1s grueso es el de Norte Am\u00e9rica con USA. Este es el pa\u00eds con m\u00e1s tiendas de H&amp;M (532 en nuestro set de datos).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Puedes cambiar las dimensiones y ver la relaci\u00f3n entre pa\u00eds y ciudad.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"1046\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-6.png\" alt=\"\" class=\"wp-image-380\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-6.png 608w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-6-174x300.png 174w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-6-595x1024.png 595w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">En este ejemplo todos los pa\u00edses, excepto China, tienen una relaci\u00f3n 1 a 1, donde su capital o una de sus ciudades principales est\u00e1 entre las top 20 con mayor n\u00famero de tiendas. China, aparte de tener Pek\u00edn (Beijing) en el top 20, tiene Shanghai, Guangzhou y Shenzhen.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"654\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-7.png\" alt=\"\" class=\"wp-image-381\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-7.png 828w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-7-300x237.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-374-7-768x607.png 768w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00bfCon qu\u00e9 otro ejemplo usar\u00edas tu el diagrama de Sankey?, \u00bftienes alguno que puedas compartir?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El diagrama de Sankey muestra c\u00f3mo se distribuye y fluye una dimensi\u00f3n, trazando m\u00faltiples caminos en direcci\u00f3n a los que [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1321,"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-374","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\/El-diagrama-de-Sankey-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-diagrama-de-Sankey-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-diagrama-de-Sankey-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-diagrama-de-Sankey-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-diagrama-de-Sankey-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-diagrama-de-Sankey-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-diagrama-de-Sankey-en-Looker-Studio.jpg",700,400,false]},"uagb_author_info":{"display_name":"barbmk","author_link":"https:\/\/lookercourses.com\/es\/author\/barbmk\/"},"uagb_comment_info":2,"uagb_excerpt":"El diagrama de Sankey muestra c\u00f3mo se distribuye y fluye una dimensi\u00f3n, trazando m\u00faltiples caminos en direcci\u00f3n a los que [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/374","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=374"}],"version-history":[{"count":2,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/374\/revisions"}],"predecessor-version":[{"id":1282,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/374\/revisions\/1282"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1321"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}