{"id":171,"date":"2024-10-27T21:09:46","date_gmt":"2024-10-27T21:09:46","guid":{"rendered":"https:\/\/lookercourses.com\/?p=171"},"modified":"2025-10-09T19:40:41","modified_gmt":"2025-10-09T19:40:41","slug":"grafico-de-area-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/grafico-de-area-en-looker-studio\/","title":{"rendered":"Gr\u00e1fico de \u00e1rea en Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">El gr\u00e1fico de \u00e1rea se usa para representar valores cuantitativos a lo largo del tiempo, y detectar tendencias y vol\u00famenes. Es parecido a las series temporales, pero este requiere la selecci\u00f3n de una dimensi\u00f3n de desglose, es decir, aparte de la dimensi\u00f3n temporal, tendremos otra m\u00e1s.<\/h3>\n\n\n\n<p>Imagina que tienes un ecommerce y que quieres representar el volumen de ventas a lo largo del tiempo por categor\u00eda de producto. En este caso la categor\u00eda de producto ser\u00eda la dimensi\u00f3n de desglose. <\/p>\n\n\n\n<p><br>  Si nuestra dimensi\u00f3n de desglose dispone de muchas categor\u00edas, puede ser dif\u00edcil de interpretar. Dimensiones como la edad, que suele tener muchos valores distintos, no es recomendable en este tipo de visualizaci\u00f3n.<br><a id=\"post-171-_cr9yd7w3k2nx\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Ejemplo<\/strong>\n<\/h2>\n\n\n\n<p>Vamos a utilizar <a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\" data-type=\"post\" data-id=\"85\">el dataset de Spotify<\/a> y a pintar en un gr\u00e1fico de \u00e1rea el n\u00famero de canciones por fecha en que se lanzaron y por modo (mayor o menor). Para eso vamos a a\u00f1adir un gr\u00e1fico de \u00e1reas apiladas.<\/p>\n\n\n\n<p>Si necesitas refrescarte la memoria sobre <a href=\"\/como-anadir-visualizaciones-a-un-informe-de-looker-studio\">c\u00f3mo a\u00f1adir gr\u00e1ficos a tu informe de Looker Studio<\/a>, visita el post dedicado al tema.<\/p>\n\n\n\n<p>En <em>Configuraci\u00f3n<\/em> del gr\u00e1fico, vamos a seleccionar <em>release_date<\/em> como <em>dimensi\u00f3n<\/em> y <em>mode<\/em> como<em> dimensi\u00f3n de desglose<\/em>. Nuestra m\u00e9trica es<em> Record count<\/em>, ya que queremos el n\u00famero de canciones y esta hace recuento del n\u00famero de filas (hay una canci\u00f3n \u00fanica por fila).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"1000\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-2.png\" alt=\"\" class=\"wp-image-173\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-2.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-2-142x300.png 142w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>As\u00ed quedar\u00eda nuestro gr\u00e1fico de \u00e1rea con la configuraci\u00f3n de arriba.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"472\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-3.png\" alt=\"\" class=\"wp-image-174\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-3.png 827w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-3-300x171.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-3-768x438.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<p>\n  Bastante dif\u00edcil de leer, \u00bfverdad?\n<\/p>\n\n\n\n<p>Vamos a cambiar el formato de la fecha, haciendo click en el l\u00e1piz a la izquierda de nuestra dimensi\u00f3n <em>release_date<\/em>. Por defecto va a mostrar que la fecha de lanzamiento (<em>release_date<\/em>) es de tipo Fecha.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"220\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-4.png\" alt=\"\" class=\"wp-image-175\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-4.png 414w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-4-300x159.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure>\n\n\n\n<p>Tenemos que cambiar <em>Fecha<\/em> por <em>A\u00f1o y Mes<\/em> como<em> Tipo de datos<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"591\" height=\"307\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-5.png\" alt=\"\" class=\"wp-image-176\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-5.png 591w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-5-300x156.png 300w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><\/figure>\n\n\n\n<p>El resultado es algo mejor, pero teniendo en cuenta que la mayor\u00eda de las canciones son de los \u00faltimos a\u00f1os, vamos a filtrar el gr\u00e1fico para que muestre datos desde 2016. He elegido 2016 porque al mirar la tabla de datos, puedo ver que 3 de las top 10 canciones son de ese a\u00f1o. <\/p>\n\n\n\n<p>Cambiando el <em>Periodo predeterminado<\/em> a <em>Personalizado<\/em> podemos elegir una fecha espec\u00edfica para el gr\u00e1fico.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"490\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-6.png\" alt=\"\" class=\"wp-image-177\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-6.png 478w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-6-293x300.png 293w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<p>En esta ventana puedes seleccionar las fechas para el gr\u00e1fico de \u00e1rea.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"532\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-7.png\" alt=\"\" class=\"wp-image-178\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-7.png 590w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-7-300x271.png 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/figure>\n\n\n\n<p>Este es el resultado.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"455\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-8.png\" alt=\"\" class=\"wp-image-179\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-8.png 826w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-8-300x165.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-8-768x423.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<p>Mucho mejor as\u00ed, aunque para lo que quiero explicar a continuaci\u00f3n, creo que es mejor limitarnos a que empiece desde enero de 2021. Quedar\u00eda as\u00ed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"463\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-9.png\" alt=\"\" class=\"wp-image-180\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-9.png 827w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-9-300x168.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-9-768x430.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<p>\n  Ahora s\u00ed, \u00bfqu\u00e9 te parece este gr\u00e1fico?, \u00bfqu\u00e9 modo dir\u00edas que ha tenido m\u00e1s canciones desde 2021? \u00bfEl mayor o el menor?\n<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"post-171-_fim33lvbtf5a\"><\/a><strong>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/strong>\n<\/h2>\n\n\n\n<p>\n  Vale la pena recordar que es un gr\u00e1fico apilado, es decir, en este caso el modo menor no empieza desde el 0 del eje izquierdo, sino que empieza en la l\u00ednea del modo mayor. En mayo de 2022 salieron 75 canciones, de las cuales 42 fueron en tono mayor y 33 en tono menor. En general hay m\u00e1s canciones en escala mayor que en menor.\n<\/p>\n\n\n\n<p>\n  Si quieres ver el gr\u00e1fico sin apilar, tienes que seleccionar uno de \u00e1reas sin m\u00e1s (sin apiladas en el nombre), o puedes ir a <em>Estilo<\/em> y desmarcar la casilla que pone <em>Mostrar la pila<\/em>.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"672\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-10.png\" alt=\"\" class=\"wp-image-181\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-10.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-10-212x300.png 212w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>\n  Quedar\u00eda as\u00ed.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"455\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-11.png\" alt=\"\" class=\"wp-image-182\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-11.png 826w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-11-300x165.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-11-768x423.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<p>Si quieres verlo apilado al 100%, adem\u00e1s de seleccionar <em>Mostrar la pila<\/em>, tienes que activar tambi\u00e9n<em> 100% apilado<\/em>. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"750\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-12.png\" alt=\"\" class=\"wp-image-183\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-12.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-12-190x300.png 190w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>A mi me gusta apilarlos al 100% cuando quiero ver el peso en porcentaje de cada una de las categor\u00edas. La \u00fanica limitaci\u00f3n es que si ves el peso en porcentaje, no vas a ver la tendencia.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"454\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-13.png\" alt=\"\" class=\"wp-image-184\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-13.png 827w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-13-300x165.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-171-13-768x422.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<p>\n  Este tipo de gr\u00e1fico tiene otras opciones, como son el a\u00f1adir l\u00edneas o bandas de referencias, que encontrar\u00e1s en <em>Estilo<\/em>.\n<\/p>\n\n\n\n<p>\u00bfC\u00f3mo prefieres utilizar el gr\u00e1fico de \u00e1rea?, \u00bfcomo gr\u00e1fico apilado, sin apilar o apilado al 100%?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El gr\u00e1fico de \u00e1rea se usa para representar valores cuantitativos a lo largo del tiempo, y detectar tendencias y vol\u00famenes. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1334,"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-171","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\/Grafico-de-area-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Grafico-de-area-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Grafico-de-area-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Grafico-de-area-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Grafico-de-area-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Grafico-de-area-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Grafico-de-area-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 gr\u00e1fico de \u00e1rea se usa para representar valores cuantitativos a lo largo del tiempo, y detectar tendencias y vol\u00famenes. [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/171","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=171"}],"version-history":[{"count":3,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"predecessor-version":[{"id":2015,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/171\/revisions\/2015"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1334"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}