Creating a "filter"

[greta2029]

Hi everyone,

I was wondering if someone could help me figure out the solution to my problem. I am using lookerstudio to display the results of my survey. Currently I adjust each graph to reflect the individual result I want to showcase by changing the Metric section and sliding the individuals username. Is there a way where I can create a button at the top of the page that would change all the graphs to show the responses of a specific individual? 

Thanks for your help!

[lauratilton]

Presumably you have a dimension of "username" or something similar? You can build a filter control using that dimension. 

[greta2029]

The problem is that each chart pulls from a different sheet in the google file. I'm wondering if there is a way to create a control that applies to all the data sets from the different sheets.

[ArkadyZagdan]

You need to create a master sheet then.
You can use multiple QUERY formula withh SELECT ALL in a new tab and plug it into looker studio.
Something like this:

{{QUERY(QUERY(Sheet1!A:Y,"select * "))};{QUERY(QUERY(Sheet2!A2:V,"select *"))};{QUERY(QUERY(Sheet3!A2:W,"select *"))}}

Its just a simple exmaple how to dynamically merge into one tab all tabs witthh a same data structure.
In 1st query yyou can pass labels and in othher you omit row number 1.

This way you will be able to do it using sheets.
Anothehr option is to push data into BigQuery and just use simple Select with Union clause to combine the data.

[lauratilton]

If you create a “bridge field” for Username it can control multiple data sources at once. Here’s a great tutorial on bridge fields.

https://youtu.be/RnprxXWJYBg?si=KyYduxRSfn-17K6H