URL Parameter Filtering with Google Sheets Data Source
Background
I'm using Looker Studio with Google Sheets as a data source and want to display reports with specific filters applied directly via URL parameters.
What I've tried
I created a parameter "class" in my data source for the Minimal Reproducible Example.
In my "Source Report," I generate links to the "Destination Report" using a calculated field with this formula:
HYPERLINK(
CONCAT(
"https://lookerstudio.google.com/reporting/YOUR_REPORT_ID/page/PAGE_ID",
"?params=%7B%22ds17.class%22%3A%22", tempGradeAndClass, "%22%7D"
),
tempGradeAndClass
)
This produces a URL such as:
.../PAGE_ID?params={"ds17.class":"1-1"}
Clicking the link successfully opens the destination report.
I wanted to make a filter for the destination page by doing the things below, but @class could not be used in the fourth input box from the left.
So instead, I tried to display the parameter's value directly in a table in the destination report. I created a new calculated field for a dimension with the formula TRIM(class). When I used this field in my table, it did not display the value from the URL (e.g., "1-1"). The column was either blank or showed a null/default value.
Current situation
- The report opens normally, but no filtering is applied.
- The parameter value (
1-1) does not appear in the filtered table columns or the table columns that the parameter is set to. - No error messages are shown.
What I tried
As a test, I tried to display the parameter's value directly in a table. I created a new calculated field for a dimension with the formula TRIM(class). When I used this field in my table, it did not display the value from the URL (e.g., "1-1"). The column was either blank or showed a null/default value.
Troubleshooting Steps Already Taken
I have already tried the following steps without success:
- Refreshing the browser page.
- Testing in an incognito window and in a different browser.
- Deleting and re-creating the class parameter.
Research findings
From the official documentation, it seems parameters are primarily supported for:
- BigQuery custom SQL queries
- Community connectors
- Variables in calculated fields
This makes me wonder if Google Sheets as a data source is simply not compatible with URL parameter-based filtering.
Questions
What is the correct method to implement URL parameter-based filtering in a Looker Studio report that uses a Google Sheets data source?
Use case
I need to link a Looker Studio report page to the filtered report page (e.g., clicking a class name in a class management system should open the report filtered only to that class but not all classes).
Environment
- Data source: Google Sheets
- Looker Studio: Latest version
Minimal Reproducible Example
I have created a minimal reproducible example that is publicly editable.
Google Sheet (Data Source): https://docs.google.com/spreadsheets/d/1V3DdpWHMT-jTl3i_xN0AljI1KIVMhFh0bBbDEb-mcLg/edit?hl=ja&gid=0#gid=0
Looker Studio Report: https://lookerstudio.google.com/reporting/6d020a73-d80c-4f08-aa0b-2c986b0a7f64/page/vxtUF
Google Sheets Sample Data
| id | tempGradeAndClass |
|---|---|
| 1 | 1-1 |
| 2 | 1-2 |
| 3 | 1-3 |
| 4 | 1-4 |
| 5 | 2-1 |
| 6 | 2-2 |
| 7 | 2-3 |
| 8 | 2-4 |
| 9 | 3-1 |
How this problem happens
Click a class
Destination Page shown and no selected class(in this case "1-1")
Then, the page's URL is this: https://lookerstudio.google.com/reporting/6d020a73-d80c-4f08-aa0b-2c986b0a7f64/page/p_4y01cnievd?params=%7B%22ds0.class%22:%221-1%22%7D
