How to enable - Filter by email in Looker Studio

[Rush1990]

Hi,

I have linked a spreadsheet with Lookerstudio and created an extract from the spreadsheet. The data contains "Email Address", For example, 1 cell contains multiple email addresses, and when I click on the "Filter by email" option in the data it does not allow me to view any data, may I know how can I rectify this?

I used this video from YouTube for reference but still, it is not working for me - Link

[ArkadyZagdan · Accepted solution]

@Rush1990 
hey Rush
If your goal is do exactly as on theh video then he is using a IF statement which is filtering the data based on an field input.
You need to create a calculated field with IF similar to this:

IF(Contains_Text( "email" - thhis must be a field with your emails, DS_USER_EMAIL, "any valid dimension"," ")

Another step is to set this as a filer on report-level. (you can do it by File--> Report Settings).


If you are using a BigQUery as a database there is a better way to aproach this.
Instead of adding a list of emails at a row level whihc is tedious work you just create a list of permissions on email level (assign each email to certain dimension value) and using Custom Query with email as parameter you just use a simple query  with WITH CLAUSE:

and email = @DS_USER_EMAIL
 

ensuring Email as a parameter have been set.:

I hope it helps:-)
Regards

Arkady Zagdan

[Rush1990]

Thank you it worked