This page explains how to enable a control on a report to filter charts based on different data sources. For example, you can make a filter control work across charts that are based on Google Sheets and BigQuery data sources. You do this by overriding field IDs at the report level.
The problem
As noted in the About controls page, fields from different data sources can have differing field IDs that are separate from their display names. Since controls are based on the field ID, filtering across data sources may fail.
The solution
If a control isn't filtering all the charts that you expect, it's likely because the field IDs don't match. You can fix this by assigning the same ID to the fields that are used in the charts.
Before you begin
Ensure you have a report that contains charts using two or more different data sources.
Override a field name or ID
To override a field's display name or ID, perform the following steps:
- In the menu, go to Resource> Manage field names and IDs.
- Click Add field override.
- From the Select a fielddrop-down, choose the field that you want to override.
- Optional: In the New display namefield, enter a new name for the field.
- In the New IDfield, enter a new ID for the field.
Notes and limitations
When changing field IDs, keep in mind the following points:
- You can change a field ID only at the report level. You can't override a field ID at the chart or data source level.
- Changing a field ID that is already in use in the report breaks any charts that use that field. You must manually select the new field in each broken chart to fix it.
- When you change multiple fields to use the same field ID, be sure that the fields are of the same data type.
Related resources
- Learn more about working with data sources .
- Learn how to add filter controls to reports .
