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.
Scorecards in Looker Studio
Scorecards in Looker Studio appear as numbers and, optionally, with the name of the metric that is 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 Soldmetric is a number from the dataset. The Avg Qty Soldmetric is a duplicate of the Qty Soldfield, with the Averageaggregation type. Total Itemsand Unique Itemsare 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:
Other types of scorecards
In addition to the basic scorecard, you can also add a preset scorecard from the toolbar that displays compact numbers.
Add the chart
Add a new chart or select an existing chart. Then, use the Propertiespanel to configure the chart's Setuptab and Styletab properties to set up the chart data and style the chart, respectively.
Set up the chart data
The options in the Setuptab of the Propertiespanel 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 the
Edit data sourceicon. (You must have at least Viewer permission
to see this icon.) - Click Blend datato see data from multiple data sources in the same chart. Learn more about data blending .
Primary field
This option lets you choose whether to display a Dimensionor a Metricvalue in your scorecard chart.
Dimensions are categories of information. The values contained in those categories are typically names, descriptions or other characteristics of that data. See the Dimension page for more information about dimensions.
Metrics
are aggregations that come from the underlying dataset 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 a metric as you can with a dimension.
After you click either the Dimensionor the Metricoption, you can choose a field from your data source.
Optional metrics
If you choose Metricas your primary field, you can set optional metrics.
You can add optional metrics by turning on the Optional metricsswitch and selecting metrics from the Add metricfield selector. You can also click metrics from the fields list on the Datapanel and place them in the Optional metricsselector.
Sparkline
When Metricis selected as Primary field, 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:
To add a sparkline to a scorecard chart, follow these steps:
- In the Sparklinesection of the Setuptab, click Add dimension.
- From the drop-down menu, select a date dimension.
- To customize the appearance of the sparkline, use the options in the Sparklinesection of the Styletab of the Propertiespanel.
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 include the following:
- Filter name:Click an existing filter to edit it. Mouse over the filter name and click Xto delete it.
- Add filter:Click this option to create a new filter for the chart.
Date range dimension
This option appears if your data source has a valid 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 that is 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 timeframe.
Default date range filter
The default date range filter lets you set a timeframe for an individual chart.
Default date range filter options include the following:
- 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.
-
Comparison date range:Displays comparison data for the selected time period.
Sort
This option appears when you set Dimensionas your primary field. You can choose to sort the Primary fieldvalues in either Ascendingor Descendingorder in the scorecard chart.
When Dimensionis selected as Primary field, you can select a different field for sorting the dimension values. For example, if a user chooses to display the values for a dimension called Country namein the scorecard chart, they can choose a Total first clicksmetric to display the Country namewith the most or the least Total first clicksin the scorecard chart. This field is optional.
Other comparison options
When Metricis selected as Primary field, the Other comparison optionsproperty 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 fieldssection of the Styletab of the Propertiespanel.
Comparison type
In the Comparison typedrop-down menu, set whether the primary metric will be compared against a period of time that you specify, a specific metric, or a specific value.
The comparison types include the following:
- Period:Specify a date range for comparison with the primary metric. This option is the default. When this option is selected, configure a time period for comparison against the primary metric by using the Comparison date rangeselector in the Default date rangesection of the Setuptab.
- 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 valuefield.
- 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 Add metricdrop-down in the Target metricfield.
- None:Select Noneto remove the comparison from the scorecard chart.
Show as progress
Turn on the Show as progressswitch to treat the comparison data as a target against which to measure the percentage of progress of the primary metric.
When Show as progressis not enabled, the calculation is displayed as the percent change for the primary metric's value in relation to the comparison data. This setting is the default.
When Show as progressis enabled, the calculation is depicted as the percentage of change for the primary metric's value in relation to the comparison data. This is the default setting.
When Show as progressis enabled, progress is depicted with a progress bar by default. You can configure how progress will be presented in the Progress Visualsection of the Styletab .
Starting value
When Metricis selected as Primary field, and the Show as progresssetting is enabled, you can specify a custom numeric value as the starting value for comparison with the primary metric.
Style the chart
The options in the Styletab control the overall presentation and appearance of the chart.
Chart title
Turn on the Show titleswitch to add a title to your chart. Looker Studio can automatically generate a title, or you can create a custom title for the chart. You can also customize the title's styling and placement.
Autogenerate
This option is enabled by default. When Autogenerateis enabled, Looker Studio generates a title that is based on the chart type and the fields that are used in the chart. The autogenerated title will be updated if you change the chart type or make changes to the fields that are used in the chart.
To add a custom title to your chart, enter it into the Titlefield. This will turn off the Autogeneratesetting.
Title options
When the Show titlesetting is enabled, you can use the following title options:
- Title:Provides a text field where report editors can enter a custom title for the chart.
- Font family:Sets the font type for the title text.
- Font size:Sets the font size for the title text.
- Font color:Sets the font color for the title text.
- Font styling options:Applies bold, italic, or underline styling to the title text.
- Top:Positions the chart title at the top of the chart.
- Bottom:Positions the chart title at the bottom of the chart.
- Left:Aligns the chart title to the left side of the chart.
- Center:Centers the chart title above or below the chart.
- Right:Aligns the chart title to the right side of the chart.
Conditional formatting
Click Add conditional formattingto apply conditional formatting rules to the chart. Learn more about conditional formatting in Looker Studio charts .
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
Thes Comparison fieldsoptions control the appearance of the scorecard's comparison data, which you can add to the chart from the Other comparison optionssection of the Setuptab. The Comparison fieldsstyle options include the following:
- Positive change color:Changes the font color that is used to indicate positively changing (upward trending) data.
- Negative change color:Changes the font color that is used to indicate negatively changing (downward trending) 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.
- Show absolute change:Changes the comparison display from percentage of change to absolute numeric difference.
- Hide comparison label:Hides the label that shows the comparison period.
Comparison label
When the Hide comparison labelsetting is not enabled, 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 Usersthat compares the number of new users in Q1 to the number of users in a past time period, Q4 of the previous year.
Sparkline
This section controls the appearance of sparkline visualizations for comparison metrics. These options appear when a sparkline is set on the Setuptab:
- 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 to indicate that there is no data:
- 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 option is the default.
Progress Visual
When the Show as progresssetting is enabled on the Setuptab, you can specify how the progress visualization will be displayed by selecting one of the following options:
- Bar:Displays the progress of the primary metric toward the target as a bar. This setting is the default.
- 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.
Missing data
When your scorecard chart is missing data, you can choose from the following options to indicate 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.
Labels
These options control the appearance of the chart labels:
- Font family:Changes the font family of the scorecard label.
- Font size:Changes the font size of the scorecard label.
- Font color:Changes the font color of the scorecard label.
- Hide field Name:Hides the default field name (which comes from the data source).
- Alignment:Aligns the field name, field value, and comparison value.
Padding
Use these options to control the line height, and the padding for the left, right, and top of the chart.
Background and border
These options control the appearance of the chart background container:
- Background:Sets the chart background color.
- 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 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.
- 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.
Chart header
The chart header lets viewers perform various actions on the chart, such as exporting the data, drilling up or down, or sorting the chart. Chart header options include the following:
- Chart header:Controls where the chart header appears on the chart. The Chart headeroptions include the following:
- Do not show:The header options never appear. Note that report viewers can always access the options by right-clicking the chart.
- Always show:The header options always appear.
- Show on hover (default):Three vertical dots appear when you hold the pointer over the chart header. Click these to access the header options.
- Header font color:Sets the color of the chart header options.
Reset to report theme
Click Reset to report themeto reset the chart settings to the report theme settings.
