{"id":186,"date":"2024-10-27T21:09:44","date_gmt":"2024-10-27T21:09:44","guid":{"rendered":"https:\/\/lookercourses.com\/?p=186"},"modified":"2025-10-09T19:40:29","modified_gmt":"2025-10-09T19:40:29","slug":"las-series-temporales-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/las-series-temporales-en-looker-studio\/","title":{"rendered":"Las series temporales en Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Las series temporales en Looker Studio son perfectas para ver c\u00f3mo evolucionan tus m\u00e9tricas a lo largo del tiempo.<\/h3>\n\n\n\n<p>En este post he utilizado <a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\" data-type=\"post\" data-id=\"85\">el dataset de top pel\u00edculas de 2019<\/a> para desarrollar los ejemplos.<\/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 a este tema.<a id=\"post-186-_ykaijvqwdeur\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Ejemplo<\/strong>\n<\/h2>\n\n\n\n<p>Para ver una serie temporal con el n\u00famero de estrenos por fecha, tienes que seleccionar <em>Fecha de estreno<\/em> como dimensi\u00f3n y <em>Record count<\/em> como m\u00e9trica dentro de Configuraci\u00f3n. Nuevamente, record count hace recuento del n\u00famero de filas.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"476\" height=\"1072\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-2.png\" alt=\"\" class=\"wp-image-188\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-2.png 476w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-2-133x300.png 133w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-2-455x1024.png 455w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/figure>\n\n\n\n<p>Este ser\u00eda el resultado.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"437\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-3.png\" alt=\"\" class=\"wp-image-189\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-3.png 828w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-3-300x158.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-3-768x405.png 768w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/figure>\n\n\n\n<p>\n  El gr\u00e1fico est\u00e1 representando los estrenos por d\u00eda y la verdad es que no es f\u00e1cil de leer, as\u00ed que vamos a cambiar la fecha, la cual muestra el d\u00eda, por el mes y el a\u00f1o en el que se estren\u00f3. Para hacer esto tienes que activar el campo que dice<em> Desglosar informaci\u00f3n<\/em>, el cual te permite ver tu dimensi\u00f3n temporal en otras tambi\u00e9n temporales. En la lista desplegable bajo<em> Nivel de desglose predeterminado<\/em>, elige <em>A\u00f1o y mes<\/em>.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"788\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-4.png\" alt=\"\" class=\"wp-image-190\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-4.png 478w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-4-182x300.png 182w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<p>Aqu\u00ed podemos ver la serie temporal con A\u00f1o y mes como dimensi\u00f3n predeterminada <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"462\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-5.png\" alt=\"\" class=\"wp-image-191\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-5.png 828w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-5-300x167.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-5-768x429.png 768w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/figure>\n\n\n\n<p>\n  Mucho mejor, \u00bfverdad? Ahora s\u00ed que se ve claramente que octubre de 2019 fue el mes en el que el mayor n\u00famero de pel\u00edculas con top ingresos fueron estrenadas.\n<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"post-186-_9hsvd27mriit\"><\/a><strong>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/strong>\n<\/h2>\n\n\n\n<p>Por defecto, el gr\u00e1fico es de l\u00edneas, pero dentro de <em>Estilo<\/em> puedes convertirlo en barras. Tambi\u00e9n puedes elegir mostrar puntos (esto solo si es l\u00ednea), etiquetas de datos o el acumulado por m\u00e9trica.<\/p>\n\n\n\n<p>Cuando quieres mostrar la evoluci\u00f3n de 2 m\u00e9tricas distintas a lo largo del tiempo, a veces es recomendable usar una l\u00ednea para una y barras para la otra. Por ejemplo, si a\u00f1ades ingresos como m\u00e9trica en el gr\u00e1fico del ejemplo anterior, tendr\u00e1s que hacer 2 modificaciones: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cambiar el eje para una de las m\u00e9tricas, ya que hay tanta diferencia entre ellas que <em>Record count<\/em> no se ve. Puedes hacerlo en <em>Estilo<\/em>, yendo a la m\u00e9trica y eligiendo <em>Eje Derecho<\/em><br>  <\/li>\n\n\n\n<li>Pintar los ingresos como barras en lugar de como l\u00ednea<br>  <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"846\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-6.png\" alt=\"\" class=\"wp-image-192\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-6.png 480w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-6-170x300.png 170w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<p>Recuerda que los ingresos muestran los generados a lo largo de los meses por las pel\u00edculas estrenadas en ese mes concreto. Si<em> Avengers: Endgame<\/em> se estren\u00f3 en abril de 2019, va a mostrarlos en ese mismo mes que se estren\u00f3, no en los meses en los que se generaron. En el gr\u00e1fico el pico de ingresos es en julio, lo cual no es de extra\u00f1ar, ya que las top 2 y 4 pel\u00edculas se estrenaron ese mes (<em>The Lion King<\/em> y <em>Spider-Man: Far from Home<\/em>, respectivamente.)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"454\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-7.png\" alt=\"\" class=\"wp-image-193\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-7.png 826w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-7-300x165.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-186-7-768x422.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<p>Las series temporales son unos de los gr\u00e1ficos m\u00e1s utilizados en Looker Studio y otras herramientas de visualizaci\u00f3n de datos. Espero que este post te haya resultado de utilidad para aprender las opciones de personalizaci\u00f3n que presenta.<\/p>\n\n\n\n<p>Como siempre, los comentarios y preguntas son m\u00e1s que bienvenidos \ud83d\ude42 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Las series temporales en Looker Studio son perfectas para ver c\u00f3mo evolucionan tus m\u00e9tricas a lo largo del tiempo. En [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1347,"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-186","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-series-temporales-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-series-temporales-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-series-temporales-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-series-temporales-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-series-temporales-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-series-temporales-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Las-series-temporales-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":"Las series temporales en Looker Studio son perfectas para ver c\u00f3mo evolucionan tus m\u00e9tricas a lo largo del tiempo. En [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/186","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=186"}],"version-history":[{"count":2,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":2014,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/186\/revisions\/2014"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1347"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}