Looker textbox default value

[Eyildiz]

Hello. I have a looker chart where I pull data from a spreadsheet. In this project, everyone sees their own information according to the number entered in an input box that I added. I set the default value to "0". When Looker opens, the data does not appear. So far, no problem. However, when you delete "0" and press enter, all the data is listed. But I only want the data to appear when the codes I give to the users are entered. Is there a solution? Thanks in advance

[Lobo-Google]

Hi @Eyildiz, thanks for your post! I believe the only way to silo data by user is to use the Filter by email address functionality in Looker Studio. The instructions and information for implementing this are outlined on the Filter by email address documentation page.

I can definitely see why it would be helpful to have more ways to filter information by user, and for them to not be able to access any other information. I would recommend filing a feature request for this - highlighting your use case would help us prioritize and understand the need for the functionality. Here are the instructions on how to file this request with our team: https://support.google.com/looker-studio/answer/7340016

Thank you!

[lauratilton]

Here's a workaround for you (here, I've used Code to mean the field in your data that you're intending that the users enter to see their own data)

- create a parameter called Code Entry which allows any value.
- use the parameter for your input box
- create a calculated field called Include which is IF(Code Entry=Code ,1,0)
- put a report-level filter on the report to only include where Include=1

This will only show records that match the code entry. If no code is entered, no data will appear.

[Lobo-Google]

That is such a smart workaround - thank you for sharing! 

[Eyildiz]

I did it but it didn't work. Can you watch the short video in the link? Where am I making a mistake?
Looker Video Link 

[HH12345]

Can you please provide video on the same issue 

[lauratilton]

Did you create a filter to include everything where "Kod Alan" is 1, and add it to the report? I didn't see that in the video.

You can create the filter under Resource > Manage filters, and then you can add it to the report under File > Report Settings.

[Eyildiz]

Yes. i'm creat filter. 

[lauratilton]

Just making sure…you’ve added the filter to the entire report under Report Settings (Filter On this Report > Add a Filter).