{"id":110,"date":"2024-10-14T15:36:12","date_gmt":"2024-10-14T15:36:12","guid":{"rendered":"https:\/\/lookercourses.com\/?p=110"},"modified":"2025-10-09T19:26:54","modified_gmt":"2025-10-09T19:26:54","slug":"el-grafico-de-bala-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/el-grafico-de-bala-en-looker-studio\/","title":{"rendered":"El gr\u00e1fico de bala en Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Al igual que el <a href=\"\/el-cuadro-de-resultados-de-looker-studio\">cuadro de resultados en Looker Studio<\/a>, el gr\u00e1fico de bala se suele utilizar para tus m\u00e9tricas m\u00e1s importantes o Key Performance Indicators. Adem\u00e1s nos dan la posibilidad de a\u00f1adir contexto a la m\u00e9trica que estamos analizando, represent\u00e1ndola junto al target o el benchmark, en forma de barra horizontal.<\/h3>\n\n\n\n<p>En este post, he utilizado <a href=\"https:\/\/lookercourses.com\/acceso-de-datasets\/\" data-type=\"post\" data-id=\"85\">los datos<\/a><a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\" data-type=\"post\" data-id=\"85\"> <\/a><a href=\"https:\/\/lookercourses.com\/acceso-de-datasets\/\" data-type=\"post\" data-id=\"85\">de Spotify<\/a> para desarrollar los ejemplos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Ejemplo<\/h2>\n\n\n\n<p>Imagina que trabajas para Spotify y uno de vuestros objetivos como empresa es que la gente reproduzca las canciones el mayor n\u00famero de veces. Para eso ten\u00e9is un dashboard en el que se incluye un gr\u00e1fico de baja donde pod\u00e9is ver el n\u00famero de reproducciones <em>-streams (millions)<\/em>&#8211; por canci\u00f3n. Aqu\u00ed vamos a ver c\u00f3mo crear dicha visualizaci\u00f3n.<\/p>\n\n\n\n<p>Si necesitas refrescarte la memoria sobre <a href=\"\/como-anadir-fuentes-de-datos-en-looker-studio\">c\u00f3mo a\u00f1adir gr\u00e1ficos a tu informe en Looker Studio<\/a>, visita el post dedicado a este tema.<\/p>\n\n\n\n<p>Una vez has a\u00f1adido tu gr\u00e1fico de bala, en dimensi\u00f3n de periodo deja <em>release_date<\/em> (dentro de Configuraci\u00f3n), ya que vamos a coger solo las canciones que salieron en julio de 2023, que es el \u00faltimo mes con datos. Para filtrar solo por este mes tienes que ir a <em>Periodo predeterminado<\/em>, en <em>Configuraci\u00f3n<\/em>, y seleccionarlo en el calendario dentro de <em>Personalizado<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter box-shadow: 5px 10px rgba(0, 0, 0.2)\"><img decoding=\"async\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-2-edited.png\" alt=\"\" class=\"wp-image-124\"\/><\/figure>\n\n\n\n<p>Como m\u00e9trica elige <em>streams (millions)<\/em>, pero como queremos el n\u00famero promedio de reproducciones por canci\u00f3n, vas a tener que cambiar la agregaci\u00f3n. Haz click donde pone <em>SUM<\/em> al lado de streams y selecciona <em>Media<\/em> debajo de <em>Agregaci\u00f3n<\/em> (consulta el post donde explico <a href=\"\/cambiar-el-tipo-de-dato-y-otras-cosas-de-tu-metrica-en-looker-studio\">los distintos tipos de agregaci\u00f3n para las m\u00e9tricas<\/a> si quieres saber m\u00e1s).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"541\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-3.png\" alt=\"\" class=\"wp-image-113\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-3.png 414w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-3-230x300.png 230w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure>\n\n\n\n<p>\n  Si has seguido los pasos hasta aqu\u00ed, ver\u00e1s que el gr\u00e1fico no tiene sentido alguno. El eje de la X solo llega hasta el 3 cuando la media de reproducciones por canci\u00f3n en las top m\u00e1s reproducidas est\u00e1 en las decenas de millones.\n<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"413\" height=\"215\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-4.png\" alt=\"\" class=\"wp-image-114\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-4.png 413w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-4-300x156.png 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/figure>\n\n\n\n<p>\n  En la configuraci\u00f3n de tu gr\u00e1fico existe la opci\u00f3n de especificar intervalos, y por defecto sus l\u00edmites est\u00e1n en el 1, el 2 y el 3. \n<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"492\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-5.png\" alt=\"\" class=\"wp-image-115\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-5.png 610w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-5-300x242.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p>\n  C\u00e1mbialos a 15, 30 y 45. Con este cambio ahora puedes ver bien que la barra azul de tu gr\u00e1fico est\u00e1 en 42 (millones), que es la media de reproducciones por canci\u00f3n para aquellas de la lista lanzadas en julio de 2023.\n<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"488\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-6.png\" alt=\"\" class=\"wp-image-116\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-6.png 616w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-6-300x238.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"413\" height=\"217\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-7.png\" alt=\"\" class=\"wp-image-117\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-7.png 413w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-7-300x158.png 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"post-110-_e7j6r6luu8ue\"><\/a>2. Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/h2>\n\n\n\n<p>\n  Adem\u00e1s de los intervalos vistos en el punto anterior, puedes pintar una l\u00ednea con el objetivo. Puedes hacerlo en <em>Configuraci\u00f3n<\/em>, debajo de los intervalos. Pongamos que el objetivo son 35 millones de reproducciones por canci\u00f3n. Quedar\u00eda as\u00ed.\n<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"424\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-8.png\" alt=\"\" class=\"wp-image-118\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-8.png 610w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-8-300x209.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p>Recuerda que la m\u00e9trica de streams est\u00e1 en millones. Por eso solo he escrito el 35 sin ceros. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"413\" height=\"218\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-9.png\" alt=\"\" class=\"wp-image-119\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-9.png 413w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-110-9-300x158.png 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/figure>\n\n\n\n<p>\u00bfQu\u00e9 te ha parecido el gr\u00e1fico de bala? \u00bfPrefieres este, el <a href=\"\/el-cuadro-de-resultados-de-looker-studio\">cuadro de resultados<\/a> o el <a href=\"\/el-indicador-con-intervalos-en-looker-studio\">indicador con intervalos<\/a> para tus Key Performance Indicators?<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Al igual que el cuadro de resultados en Looker Studio, el gr\u00e1fico de bala se suele utilizar para tus m\u00e9tricas [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1325,"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-110","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-grafico-de-bala-en-Looker-Studio-1.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-bala-en-Looker-Studio-1-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-bala-en-Looker-Studio-1-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-bala-en-Looker-Studio-1.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-bala-en-Looker-Studio-1.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-bala-en-Looker-Studio-1.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-bala-en-Looker-Studio-1.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 el cuadro de resultados en Looker Studio, el gr\u00e1fico de bala se suele utilizar para tus m\u00e9tricas [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/110","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=110"}],"version-history":[{"count":2,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/110\/revisions"}],"predecessor-version":[{"id":1196,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/110\/revisions\/1196"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1325"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}