AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.5K members online now
1.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Can I filter a table by user email?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a sheet showing business leads and details and the sales rep (by login email). Can I create a table to show those details and only allow each rep to see their own lead details? I thought I could accomplish this by creating a filter on the table where the email address equals "Session.getActiveUser().getEmail()". That didn't work (or I suppose I wouldn't be posting this). Any suggestions? It would be great to deploy one datastudio that all the reps could use to get the reports that are relevant to them (filter by active user email). Thanks in advance for any help.

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Andrew C
May 2017

Can I filter a table by user email?

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

Hi Andrew,

 

if I am not wrong, you'd have to setup one report for each sales rep as long as user permissions are handled on that level in data studio.

 

 

Best regards, 

 

Malte

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Andrew C
May 2017

Can I filter a table by user email?

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

Hi Andrew,

 

if I am not wrong, you'd have to setup one report for each sales rep as long as user permissions are handled on that level in data studio.

 

 

Best regards, 

 

Malte

Re: Can I filter a table by user email?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thank you. Yes that is what we are doing now. We were hoping for a way to
make one report that all the reps could use and just see their results.
Maybe Google will add that functionality?

*Andrew Conway* P.Eng.
Vice President
*Mobile: 416-990-2446 <416-990-2446>*
ISO9001/ISO14001/OHSAS18001/DEL certified
Please take our Customer Satisfaction Survey (only 5 questions)

Re: Can I filter a table by user email?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Thanks for your reply. That is what we are doing. I was just wondering if I
was missing something to make it so we could just deploy one. Thanks.

*Andrew Conway* P.Eng.
Dimachem Inc. Vice President

Can I filter a table by user email?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hello Andrew, 

 

I have the same problem, but there are ~2800 reps, so I don't want create 1 table for each rep... If you find a solution, please share.

 

Thank you,

Regards

Annelise

Can I filter a table by user email?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Hi Annelise

 

Did you find an answer to this problem as I am in the same position as you. 

 

Many thanks

Ricky

Re: Can I filter a table by user email?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭
I did not Smiley Sad

*Andrew Conway* P.Eng.
Dimachem Inc. Vice President
*Mobile: 416-990-2446 <416-990-2446>*
ISO9001/ISO14001/OHSAS18001/DEL certified