When using filter by e-mail is it possible to see all data while editing?

Looker Q&A Looker Studio
1

Hi all,

I’m setting up a reporting dashboard for our partners using google sheets and looker studio. I would like to create one dashboard with all of the information, and use filter by e-mail so when sharing with our partners, they only see their data. I’ve gotten this figured out, but what I don’t understand is how I as the owner/editor can see all of the data. With filter by e-mail, I only see the data associated with the e-mail I’m logged in to. Is there a way to give my e-mail access to all rows? Or is there another work around people use for this?

Thank you!

2

With a Sheets source, you’d need to make a copy of the dashboard for yourself that doesn’t use filter by email.

If you were using BigQuery, you could use the DS_USER_EMAIL parameter in a custom query that allowed multiple email addresses to access the same record. More info here. Once upon a time, that parameter was available directly in Looker Studio, but it’s no longer there.