{"id":93,"date":"2024-10-14T15:23:57","date_gmt":"2024-10-14T15:23:57","guid":{"rendered":"https:\/\/lookercourses.com\/?p=93"},"modified":"2025-10-09T19:26:54","modified_gmt":"2025-10-09T19:26:54","slug":"el-cuadro-de-resultados-de-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/el-cuadro-de-resultados-de-looker-studio\/","title":{"rendered":"El cuadro de resultados de Looker Studio"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">El cuadro de resultados o scorecard es uno de los gr\u00e1ficos m\u00e1s utilizados en Looker Studio. Se suele usar para monitorizar las m\u00e9tricas m\u00e1s importantes o Key Performance Indicators.<\/h3>\n\n\n\n<p>En este post voy a desarrollar un ejemplo usando los datos de <a href=\"\/como-crear-dimensiones-con-campos-personalizados-en-looker-studio\">top pel\u00edculas de 2019<\/a> para mostrar qu\u00e9 opciones de configuraci\u00f3n tiene esta visualizaci\u00f3n. Sigue los pasos explicados en el post sobre <a href=\"\/como-anadir-fuentes-de-datos-en-looker-studio\">fuentes de datos en Looker Studio<\/a> para a\u00f1adir los datasets a tu informe y as\u00ed poder replicar los ejemplos que ver\u00e1s aqu\u00ed.\u00a0<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplo<\/h2>\n\n\n\n<p>Vamos a crear un cuadro de resultados con los datos de las top pel\u00edculas de 2019. El ranking est\u00e1 determinado por los ingresos que ha tenido cada una, as\u00ed que esta es la m\u00e9trica que vamos a representar.<\/p>\n\n\n\n<p>Al seleccionar el cuadro de resultados dentro de <em>A\u00f1adir un gr\u00e1fico<\/em>, el cursor del rat\u00f3n encima del lienzo indica que el gr\u00e1fico se dibujar\u00e1 donde hagas click.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"438\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-2.png\" alt=\"\" class=\"wp-image-95\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-2.png 828w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-2-300x159.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-2-768x406.png 768w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/figure>\n\n\n\n<p>Si haces click para que se pinte, podr\u00e1s empezar a configurarlo en <em>Configuraci\u00f3n<\/em> dentro de <em>Propiedades<\/em>, que aparecer\u00e1 a la derecha del lienzo. El valor que quieras representar debes seleccionarlo dentro de <em>M\u00e9trica<\/em>. En este caso nos interesan los ingresos de las top pel\u00edculas, as\u00ed que eso es lo que vamos a elegir.<\/p>\n\n\n\n<p>Tambi\u00e9n ver\u00e1s que existe un campo llamado<em> dimensi\u00f3n de periodo<\/em>. \u00c9ste es relevante si quieres representar un periodo concreto. Por ejemplo, imagina que quieres ver los ingresos solo de las pel\u00edculas estrenadas los primeros 3 meses del a\u00f1o. Para eso debes usar<em> Fecha de estreno<\/em> en este campo, que deber\u00eda haber salido por defecto, pero si no es as\u00ed, puedes elegirla tu mismo. Ahora si cambias el periodo predeterminado a <em>personalizado<\/em> y eliges el primer trimestre de 2019, ver\u00e1s que el total de ingresos en el cuadro de mando cambia.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"1588\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-3.png\" alt=\"\" class=\"wp-image-96\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-3.png 480w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-3-91x300.png 91w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-3-464x1536.png 464w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<p>Puedes leer m\u00e1s sobre la dimensi\u00f3n de periodo en el post sobre el <a href=\"\/el-filtro-por-periodo-o-como-seleccionar-fechas-determinadas-en-looker-studio\">filtro por periodo<\/a>, pero, en resumen, las fechas de este campo son las que se filtran cuando le asignas una fechas espec\u00edficas al gr\u00e1fico o si utilizas un filtro por periodo. Imagina que el dataset tiene 2 campos con fechas: fecha de estreno en Estados Unidos y fecha de estreno en Espa\u00f1a. La que elijas dentro de dimensi\u00f3n de periodo determinar\u00e1 qu\u00e9 datos se muestran cuando limites el gr\u00e1fico a unas fechas concretas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"post-93-_z5a5wla6evsy\"><\/a>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/h2>\n\n\n\n<p>En <em>Configuraci\u00f3n<\/em> existe la opci\u00f3n de a\u00f1adir un minigr\u00e1fico en el cuadro de resultados. Si seleccionas <em>Fecha de estreno<\/em>, ver\u00e1s el minigr\u00e1fico por d\u00eda en los que se estrenaron pel\u00edculas.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"636\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-4.png\" alt=\"\" class=\"wp-image-97\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-4.png 482w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-4-227x300.png 227w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"372\" height=\"222\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-5.png\" alt=\"\" class=\"wp-image-98\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-5.png 372w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-5-300x179.png 300w\" sizes=\"auto, (max-width: 372px) 100vw, 372px\" \/><\/figure>\n\n\n\n<p>Bajo <em>Minigr\u00e1fico<\/em> ver\u00e1s <em>Otras opciones de comparaci\u00f3n<\/em>. Esto te permite elegir una m\u00e9trica, un valor o un periodo con el que comparar los ingresos, que es la m\u00e9trica de nuestro cuadro de resultados. Vamos a compararlo con un valor y a\u00f1adir 5500 millones como el valor objetivo. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"476\" height=\"606\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-6.png\" alt=\"\" class=\"wp-image-99\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-6.png 476w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-6-236x300.png 236w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/figure>\n\n\n\n<p>Como puedes ver, los ingresos son un 8% superiores al valor objetivo que hemos puesto.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"372\" height=\"222\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-7.png\" alt=\"\" class=\"wp-image-100\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-7.png 372w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-7-300x179.png 300w\" sizes=\"auto, (max-width: 372px) 100vw, 372px\" \/><\/figure>\n\n\n\n<p>Debajo del campo donde has escrito tu objetivo de 5500 millones, ver\u00e1s que pone <em>Mostrar como progreso<\/em>. Si lo activas, en el cuadro de resultados se pintar\u00e1 una barra comparando el progreso con respecto a tu valor objetivo, y desaparecer\u00e1 el minigr\u00e1fico (no pueden pintarse ambos a la vez).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"616\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-8.png\" alt=\"\" class=\"wp-image-101\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-8.png 468w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-8-228x300.png 228w\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"251\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-9.png\" alt=\"\" class=\"wp-image-102\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-9.png 419w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-9-300x180.png 300w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/figure>\n\n\n\n<p>Si dentro de <em>Otras opciones de comparaci\u00f3n<\/em> cambias <em>Tipo de comparaci\u00f3n<\/em> a periodo, debes a\u00f1adir un periodo de comparaci\u00f3n dentro de<em> Periodo predeterminado<\/em>. Para verlo en el ejemplo, he seleccionado del 1 al 31 de marzo de 2019 como<em> Periodo predeterminado,<\/em> y <em>Periodo anterior<\/em> (en este caso es el mes anterior) como <em>Periodo de comparaci\u00f3n<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"950\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-10.png\" alt=\"\" class=\"wp-image-103\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-10.png 468w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-10-148x300.png 148w\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"257\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-11.png\" alt=\"\" class=\"wp-image-104\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-11.png 420w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-11-300x184.png 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/figure>\n\n\n\n<p>Si vas a <em>Estilo<\/em> y buscas<em> Visualizaci\u00f3n del progreso<\/em>, hay una lista desplegable donde puedes cambiar la barra por un c\u00edrculo.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"340\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-12.png\" alt=\"\" class=\"wp-image-105\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-12.png 468w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-12-300x218.png 300w\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"255\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-13.png\" alt=\"\" class=\"wp-image-106\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-13.png 420w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-13-300x182.png 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/figure>\n\n\n\n<p>Tambi\u00e9n en <em>Estilo<\/em>, si seleccionas<em> N\u00fameros compactos<\/em>, la m\u00e9trica en el cuadro de resultados se mostrar\u00e1 de forma acortada y con una M de Millones. A m\u00ed me gusta usar esta opci\u00f3n cuando trabajo con valores muy elevados, ya que de esta forma son m\u00e1s f\u00e1ciles de leer.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"600\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-14.png\" alt=\"\" class=\"wp-image-107\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-14.png 480w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-14-240x300.png 240w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"253\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-15.png\" alt=\"\" class=\"wp-image-108\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-15.png 419w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-93-15-300x181.png 300w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/figure>\n\n\n\n<p>\u00bfQu\u00e9 te ha parecido el cuadro de resultados? \u00bfConoc\u00edas todas la opciones que ofrece? Como siempre, los comentarios son m\u00e1s que bienvenidos \ud83d\ude42 <\/p>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>El cuadro de resultados o scorecard es uno de los gr\u00e1ficos m\u00e1s utilizados en Looker Studio. Se suele usar para [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1320,"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-93","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-cuadro-de-resultados-de-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-resultados-de-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-resultados-de-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-resultados-de-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-resultados-de-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-resultados-de-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-cuadro-de-resultados-de-Looker-Studio.jpg",700,400,false]},"uagb_author_info":{"display_name":"barbmk","author_link":"https:\/\/lookercourses.com\/es\/author\/barbmk\/"},"uagb_comment_info":1,"uagb_excerpt":"El cuadro de resultados o scorecard es uno de los gr\u00e1ficos m\u00e1s utilizados en Looker Studio. Se suele usar para [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/93","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=93"}],"version-history":[{"count":1,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/93\/revisions"}],"predecessor-version":[{"id":1191,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/93\/revisions\/1191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1320"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}