{"id":215,"date":"2024-11-04T15:13:55","date_gmt":"2024-11-04T15:13:55","guid":{"rendered":"https:\/\/lookercourses.com\/?p=215"},"modified":"2025-10-09T19:26:59","modified_gmt":"2025-10-09T19:26:59","slug":"el-grafico-combinado-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/el-grafico-combinado-en-looker-studio\/","title":{"rendered":"El gr\u00e1fico combinado en Looker Studio"},"content":{"rendered":"\n

Esta es una de mis visualizaciones preferidas cuando quiero mostrar 2 m\u00e9tricas distintas para una misma categor\u00eda. <\/h2>\n\n\n\n

Para construir un gr\u00e1fico combinado, se puede hacer a partir de una de barras o columnas haciendo modificaciones en Estilo<\/em>, aunque eligiendo gr\u00e1fico combinado<\/em> desde el principio se hace mucho m\u00e1s r\u00e1pido.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Recuerda que si necesitas refrescarte la memoria sobre c\u00f3mo a\u00f1adir visualizaciones a tu informe de Looker Studio<\/a>, puedes hacerlo en el post sobre ello.<\/a><\/p>\n\n\n\n

Ejemplo<\/strong>\n<\/h2>\n\n\n\n

En este ejemplo vamos a seguir trabajando con el dataset de top pel\u00edculas de 2019<\/a>.<\/p>\n\n\n\n

Hasta ahora hemos visto los ingresos por g\u00e9nero principal. Ahora vamos a ver tambi\u00e9n cu\u00e1ntas pel\u00edculas hubo, entre las top generadoras de ingresos, para esta categor\u00eda. Para ello, en la configuraci\u00f3n de tu gr\u00e1fico, elige G\u00e9nero principal 1<\/em> en dimensi\u00f3n, y en m\u00e9trica selecciona tanto Record count<\/em> como Ingresos<\/em>. <\/p>\n\n\n\n

Ordena el gr\u00e1fico por ingresos como aparece bajo Ordenar<\/em> en la image de abajo.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Este es el resultado al seguir la configuraci\u00f3n del gr\u00e1fico combinado con ingresos y n\u00famero de pel\u00edculas por g\u00e9nero principal 1 ordenado por ingresos descendentes <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Te estar\u00e1s preguntando por qu\u00e9 no aparece el n\u00famero de pel\u00edculas (Record count<\/em>). Lo que pasa es que ambas m\u00e9tricas est\u00e1n utilizando el mismo eje, y al ser Record count<\/em> much\u00edsimo m\u00e1s bajos que los ingresos, no se ven. Vamos a hacer las modificaciones oportunas en la columna Estilo<\/em> para que aparezcan.<\/p>\n\n\n\n

<\/a>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/strong>\n<\/h2>\n\n\n\n

Para cambiar el eje de una de las m\u00e9tricas se hace como vimos anteriormente para el gr\u00e1fico de barras o columnas<\/a>. Esto est\u00e1 disponible en Estilo<\/em>, yendo al n\u00famero de m\u00e9trica y seleccionando Eje Izquierdo<\/em> o Derecho<\/em>. Cuando digo n\u00famero de m\u00e9trica me refiero a Serie n\u00famero 1, 2, 3, etc… Tendr\u00e1s tantas series como m\u00e9tricas tenga tu gr\u00e1fico (en este caso 2).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Al cambiar el eje de los ingresos, ya podemos ver Record count<\/em> en el gr\u00e1fico.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

El resto de opciones son muy parecidas a las que ya vimos en el gr\u00e1fico de barras o columnas<\/a>. La mayor diferencia es que para tener un gr\u00e1fico con doble eje hay que elegir serie por serie, dentro de Estilo<\/em>, qu\u00e9 eje va a utilizar.<\/p>\n\n\n\n

\u00bfQu\u00e9 te parece esta visualizaci\u00f3n?, \u00bftienes alguna pregunta o comentario?<\/p>\n","protected":false},"excerpt":{"rendered":"

Esta es una de mis visualizaciones preferidas cuando quiero mostrar 2 m\u00e9tricas distintas para una misma categor\u00eda. Para construir un […]<\/p>\n","protected":false},"author":2,"featured_media":1324,"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-215","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-combinado-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-combinado-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-combinado-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-combinado-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-combinado-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-combinado-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-combinado-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":"Esta es una de mis visualizaciones preferidas cuando quiero mostrar 2 m\u00e9tricas distintas para una misma categor\u00eda. Para construir un […]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/215","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=215"}],"version-history":[{"count":1,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":1264,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/215\/revisions\/1264"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1324"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}