Add optional metrics to charts and tables.
You can make your charts and tables more flexible by adding optional metrics. This lets your viewers select which columns or fields to display in the chart.
Add optional metrics
- Edit your report.
- Select or add a chart.
- On the right, in the properties panel under Metric, turn on Optional metrics.
- Click +Add metric or drag the metric from the Available fields panel.
Select optional metrics in a chart
- View your report.
- Hover over a chart with optional metrics, then in the header, click
.
- Select the optional metrics from the list.
The number of optional metrics you can select depends on the chart type and number of required metrics already present in the chart.
Restore the default fields
To revert the chart to its default field set, hover over the chart, then click .
Limits of optional metrics
- You can have a maximum of 10 optional metrics per chart.
- Optional metrics are not available for pivot tables, scatter charts, and Google Maps.