Notification

This Help Center is moving to Cloud. Learn more about the migration.

Optional metrics

Let your users choose the metrics to display in charts and tables.

You can make your charts and tables more flexible by adding optional metrics. You can change the columns or fields that you want to see in the chart without having to edit the chart configuration each time.

Add optional metrics

  1. Edit your report.
  2. Select or add a chart.
  3. In the Properties panel, select the SETUP tab.

  4. Under Metric, turn on Optional metrics.
  5. Click +Add metric or drag the metric from the Available fields panel.

Select optional metrics in a chart

  1. View or edit your report.
  2. Hover over a chart with optional metrics; then, in the header, click the Optional metrics icon .
  3. Select the optional metrics from the list.

Restore the default fields

To revert the chart to its default field set, hover over the chart and click the Reset icon Undo.

Limits of optional metrics

  • The number of optional metrics that you can select depends on the number of required metrics that are already present in the chart and the chart type:
    • Table and pivot table: The maximum is determined by the maximum number of metrics that are allowed by the chart, which depends on the data source. The maximum typically ranges from 20-100.
    • Bar/Line/Combo: 20.
    • Every other chart: 100.
  • Optional metrics are not available for scatter charts or Google Maps.

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
14729073050503612153
true
Search Help Center
true
true
true
true
true
102097
false
false