Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

Scorecard reference

How to use and configure scorecards.

Scorecards display a summary of a single metric. Scorecards are commonly used to visualize key performance indicators or some other variable that measures the relative health or performance of your business or area of activity. For example, a scorecard can summarize total sales, average bounce rate, count of ad impressions, maximum hold time, minimum failure rate, etc.

In this article:

Scorecards in Looker Studio

Scorecards in Looker Studio appear as numbers and, optionally, with the name of the metric being summarized. The format of the displayed number depends on how the metric is configured in your data source.

Example:

The data source for a fictional pet store contains the metrics Qty Sold, Avg Qty Sold, Total Items, and Unique Items. The Qty Sold metric is a number from the data set. The Avg Qty Sold metric is a duplicate of the Qty Sold field, with the Average aggregation type. Total Items and Unique Items are calculated fields.

Name Calculation Aggregation Type
Qty Sold none Sum
Avg Qty Sold none Average
Total Items COUNT(Items) Auto
Unique Items COUNT_DISTINCT(Items) Auto

Scorecards for these metrics might look like this:

Scorecards for Qty Sold, Total Items, Avg Qty Sold, and Unique Items data.

Other types of scorecards

In addition to the basic scorecard, you can also add a preset scorecard from the toolbar that displays compact numbers.

A scorecard showing 354,700 views. The metric is represented as 354.7K.

Configure the chart

Add a new chart or select an existing chart. Then, on the right, use the Properties panel to configure the chart's Setup and Style tab properties.

Set up the chart data

The options in the SETUP tab determine how the chart's data is organized and displayed.

Data source

A data source provides the connection between the component and the underlying dataset. 

  • To change the chart's data source, click the current data source name.
  • To view or edit the data source, click Edit. (You must have at least view permission to see this icon.)
  • Click +BLEND DATA to see data from multiple data sources in the same chart. Learn more about data blending.

Date range dimension

This option appears if your data source has a valid date dimension.

Note: This option does not appear for Google Ads or Google Analytics data sources, as these automatically use a Date dimension.

The Date range dimension is used as the basis for limiting the date range of the chart. For example, this is the dimension used if you set a date range property for the chart, or if a viewer of the report uses a date range control to limit the time frame.

Metric

Metrics measure the things that are contained in dimensions and provide the numeric scale and data series for the chart.

Metrics are aggregations that come from the underlying data set, or that are the result of implicitly or explicitly applying an aggregation function, such as COUNT(), SUM(), or AVG(). The metric itself has no defined set of values, so you can’t group by it as you can with a dimension.

Learn more about aggregation.

Optional metrics

Define a list of additional metrics that can be displayed by the chart or table. Learn more about optional metrics.

Sparkline

You can add a sparkline to a scorecard chart to visualize your primary metric's trends over time. For example, in the following scorecard chart, a blue sparkline shows the trend over time for the primary metric, New Users. The sparkline is displayed below both the value for the primary metric and the percentage for the optional comparison metric:

Scorecard chart with a sparkline displaying trends over time for the primary metric, New Users. The sparkline appears below the primary metric value and the comparison metric percentage.

To add a sparkline to a scorecard chart, follow these steps:

  1. In the Sparkline section of the Setup tab, select the Add dimension option.
  2. Select the desired date dimension from the drop-down menu.
  3. To customize the appearance of the sparkline, use the options in the Sparkline section of the Style tab of the properties panel.
You cannot add a sparkline to a scorecard chart that has the Show as progress checkbox selected.

Other Comparison Options

The Other Comparison Options property lets you specify a period of time, a specific metric, or a specific value against which to compare the primary metric for your scorecard chart.

You can configure the visual format of the comparison value in the Comparison Fields section of the Style tab of the properties panel.

Comparison type options

In the Comparison type section of the Setup tab, set whether the primary metric will be compared against a period of time that you specify, a specific metric, or a specific value.

Period

Specify a date range for comparison with the primary metric. This is the default option.

When this option is selected, configure a time period for comparison against the primary metric by using the Comparison date range selector in the Default date range section of the Setup tab.

Value

Enter a numerical value or use the upward or downward arrows to select a number to use for comparison with the primary metric.

When you select this option, enter a numeric value against which to compare the primary metric's value in the Target value field.

Metric

Select another metric to compare with the primary metric.

When you select this option, specify another metric against which to compare the primary metric by selecting a field from the the Add metric drop-down in the Target metric field.

None Select None to remove the comparison from the scorecard chart.

Show as progress

Select the Show as progress checkbox to treat the comparison data as a target against which to measure the percentage of progress of the primary metric.

When the Show as progress checkbox is not selected, the calculation is depicted as the percent of change for the primary metric's value in relation to the comparison data. This is the default setting.

Scorecard chart with progress toward target for New Users metric depicted as a negative percentage.

When the Show as progress checkbox is selected, the calculation is depicted as the percent of progress of the primary metric toward the comparison data from the starting value.

Scorecard chart with progress toward target for New Users metric depicted as a progress bar indicating 89.6% completion.

When Show as progress is selected, progress is depicted with a progress bar by default. You can configure how progress will be presented in the Progress Visual section of the Style tab.

If the Show as progress checkbox is selected, you cannot add a sparkline visualization to your scorecard chart.

Starting value

When the Show as progress checkbox is selected, you can specify a custom numeric value as the starting value for comparison with the primary metric.

Default date range

The Default date range property lets you set a timeframe for an individual chart.

Default date range options

Auto Uses the default date range, which is determined by the chart's data source.
Custom Lets you use the calendar widget to select a custom date range for the chart.
Date compare type Displays comparison data for the selected time period.

Learn more about working with dates and time. 

Filter

Filters restrict the data that is displayed in the component by including or excluding the values that you specify. Learn more about the filter property.

Filter options

Filter name Click an existing filter to edit it. Mouse over the filter name and click X to delete it.
+Add a filter Click this option to create a new filter for the chart.

Google Analytics segment

This option appears for charts based on a Universal Analytics data source.

A segment is a subset of your Analytics data. You can apply segments to your Looker Studio charts to help ensure that your Looker Studio and Google Analytics reports show the same data. Learn more about Analytics segments in Looker Studio.

Stylize the chart

The options in the Style tab control the overall presentation and appearance of the chart.

 

Conditional formatting

Apply conditional formatting rules to the chart.

 

Primary metric

These options control the appearance of the scorecard's current data.

Compact Numbers

Rounds numbers and displays the unit indicator. For example, 553,939 becomes 553.9K.

Decimal Precision Sets the number of decimal places in metric values.

Comparison Fields

These options control the appearance of the scorecard's comparison data, which you can add to the chart from the Other Comparison Options section of the Setup tab.

Positive change color Changes the font color used to indicate positively changing (upward trending) data.
Negative change color Changes the font color used to indicate negatively changing (downward trending) data.
Show absolute change Changes the comparison display from percentage of change to absolute numeric difference.
Compact Numbers

Rounds numbers and displays the unit indicator. For example, 553,939 becomes 553.9K.

Decimal Precision Sets the number of decimal places in metric values.
Hide comparison label

Hides the label that shows the comparison period.

Comparison label

When the Hide comparison label checkbox is not selected, you can edit the label for the comparison. For example, you can add the label "Q4 new users" to a scorecard chart with a primary metric of New Users that compares the number of new users in Q1 to the number of users in a past time period, Q4.

Scorecard chart with the text 90.4% Q4 new users above a progress bar indicating the progress of the New Users metric.

Sparkline

This section controls the appearance of sparkline visualizations for comparison metrics.

Sparkline color Changes the color of the sparkline.
Fill Fills the sparkline with a lighter shade of the sparkline color.
Smooth

Displays series lines as curves.

Missing data Sets how the sparkline will display missing data.

Missing data for sparkline

When your sparkline is missing data, you can choose one of the following options.

Line to Zero When this option is selected, a line series will drop to zero for the missing dates.
Line Breaks When this option is selected, missing data appears as breaks in the data series.
Linear Interpolation When this option is selected, Looker Studio will continue the series by connecting the data points on either side of the missing data. This is the default option.

Progress visual

When the Show as progress checkbox is selected on the Setup tab, you can specify how the progress visualization will be displayed by selecting an option from the Progress Visual Type section.

Bar

Displays the progress of the primary metric toward the target as a bar. This is the default setting.

Circle Displays the progress of the primary metric toward the target as a circle.
None Removes the progress bar or progress circle from the scorecard chart.

Labels

This section controls the appearance of the chart labels.

Font color Changes the font color of the scorecard label.
Font size Changes the font size of the scorecard label.
Font family Changes the font family of the scorecard label.
Hide Metric Name Hides the default metric name (which comes from the data source). You can use the Text tool to add a custom metric label.
Alignment Aligns the metric name, primary value, and comparison value.

Missing data

When your scorecard chart is missing data, you can choose from the following options for indicating that there is no data.

Show "No data" Displays the text "No data" on the scorecard chart.
Show "0" Displays the number "0" on the scorecard chart.
Show "-" Displays the text "-" on the scorecard chart.
Show "null" Displays the text "null" on the scorecard chart.
Show " " (blank) Displays no text on the scorecard chart.

Background and border

These options control the appearance of the chart background container.

Background Sets the chart background color.
Border Radius Adds rounded borders to the chart background. When the radius is 0, the background shape has 90° corners. A border radius of 100° produces a circular shape.
Opacity Sets the chart opacity. 100% opacity completely hides objects behind the chart. 0% opacity makes the chart invisible.
Border Color Sets the chart border color.
Border Weight Sets the chart border line thickness.
Border Style Sets the chart border line style.
Add border shadow Adds a shadow to the chart's lower and right borders.

Padding

Use these options to control the line height and left, right, and top padding within the chart.

Chart Header

The chart header lets viewers perform various actions on the chart such as exporting the data or sorting the chart. The following chart header options are available:

Show on hover (default) Three vertical dots appear when you mouse over the chart header. Click these dots to access the header options.
Always show The header options always appear.
Do not show The header options never appear. Note that report viewers can always access the options by right-clicking the chart.
Color Sets the color of the chart header options.

Was this helpful?

How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
8182538264688228916
true
Search Help Center
true
true
true
true
true
102097