Problem with data visibility

[GfilorG]

Hi guys nice to meet you all, i'm very new at Looker Studio.

I have sort of a problem with a report.

Basically i would like to share a report with different people but each of them must see only specific rows.

I found a solution for this, and that was creating a column with emails (Agent-Email) and filter data by viewer email.

Then i have another problem 🙂

Essentially people can have two profile. 1) Agents. 2) retailers, but the problem is that they can have both.

each of them have only one email but i need to create another column (Email-Retail) and do the same thing (filter data by viewer email). 

How can i filter using two columns ? 

Thank you so much 

[sam8]

Tricky! As far as I know, you can only filter on one email. 

Maybe you should make two reports - an agent report which can be filtered by agent email, and then a retailer report which can be filtered by retail email?

[阿泰]

How about using the table filter and adding more conditions in a table? See the screenshot below:

[lauratilton]

If you want to use filter by email, you'll need to choose one email field, unfortunately. The easiest solution (as Sam said) is to create two copies of the report and filter by email differently on each one.

If your data is in BQ, you can use the email parameter (@DS_USER_EMAIL) in a custom query which will allow you to compare it to both email fields. Once upon a time this parameter was available in Looker Studio directly, but not anymore.