Google Sheets - Create Separate Report Filtered for Each User using Data Studio
Learn how to create Google account specific reports using Google Sheets data and display a separate filtered report for each user using Google Data Studio.
Sign up to get updates, practice files and code snippets eepurl.com/hwyGg1
#googlesheets #datasstudio #report
Пікірлер: 52
Man, ALL your vids are GOLD. thx for everything you do.
This blew my mind! Thank you so much for this.
Being waiting this guide for so long... Thank your so much.. Never stop to amaze us...
@nocodeexplorer
3 жыл бұрын
Hi @muhammad. You could also achieve the same functionality on Utilize (www.utilize.app) on your mobile devices.
You are doing amazing work!! I really appreciate your work
this is great! and maybe if you were wanting to filter by region/team/roles/etc , you could add a blend with the sales data relating to the spreadsheet you created , so the filter waterfalls trough the data, and you can see not only your own sales, but your team's , or whatever your role lets you see.
@rajendranj3442
Жыл бұрын
I need to understand this concept for Roles. I want to make the leader of a team to view all the report. How should I make it?
I love your videos. I always look for your new videos.
That's great! Thanks a lot. One question regarding the printing, if you can suggest some solution: How to get a long table to show data across multiple pages? I have a table that I wish to include in a report that has about 300 rows of data. I have included the table on a single page, and when I print out the report to PDF, I can only see a single page with about 50 rows.
Sir ur teaching is really great, I can't English bt m trying to speak English... Bt sir m understand ur English, I have found your videos very helpful in working with Google Sheets.. Thx sir..
Thank you for great video. Is there a similar way to show/hide pages for specific users?
That's new for me and awesome!
It's good one. Sir.. I learnt a lot from your videos... what is the work around If I need to extend access for multiple accounts like department head and CEO. I know it can be done if the data source is from bigquery. Can we achieve it with the spreadsheet data source.
Can you schedule an email delivery of this report for all of the sales representative but with access to view in the email their own data?
THank you
YOU'RE AMAZING!!!
@mahhasrab
2 жыл бұрын
Thanks alot With filttering by email is it possible to give Authority to an Emil to see all records?
Sir, Awesome video. is there any way to refresh data studio prior to 15 minutes. any addons or any other method. pls suggest if it is possible
@genysisonline8496
3 жыл бұрын
Not entirely sure but try this Chrome Extension: chrome.google.com/webstore/detail/data-studio-auto-refresh/inkgahcdacjcejipadnndepfllmbgoag
@crabfriedrice
3 жыл бұрын
I think you can click on the 3 dots next to view and click refresh.
Thanks! I am using this in the current task. One question. Can i use Apps Script to edit share settings in Data Studio reports?
@ExcelGoogleSheets
3 жыл бұрын
I don't think it's possible.
@nocodeexplorer
3 жыл бұрын
Hi @dsky. If you want the same functionality when you want change access dynamically, you can use Utilize (www.utilize.app). On Utilize you can create an app and add/remove users dynamically.
Awesome 👌 👏 👍 😍
What if I want to link two or multiple sheets with same data month on month, it should just be a source in continuation of next month and so on. Please advise. No blending here
Neat!
I thought it could be an option for each person with an user an key, could entry and see its own data, anyway it 's ok as all your videos. I would like to learn how to upload a file from a google form (app script) as i know how to download but not how to upload and see the file from the form. I thought maybe with this video i could learn how to show the file from the google sheet to a particular person and avoid he can see the others rows, but it refer to other thing . Thank you!
Oh my god! I used import range on so many sheets already. Thank you so much for this! But can this be used if there are 2 or 3 sales reps in connection of 1 Sales? 1. Example: This Guy and Nia sales the same Undershirt (the data is input on the same row). This Guy account for 50% of the Sales and Nia account for the other 50% How can This Guy see only 50% of the original Sales amount with Data Studio? Reps 1 Reps support item Total Sales This Guy Nia Shirts 5000 2. Except for this function, do you think the Data Studio is the same as Pivot table?
@ExcelGoogleSheets
3 жыл бұрын
1. No. You would have to duplicated those lines. 2. For the most part, yes.
@nghilam483
3 жыл бұрын
@@ExcelGoogleSheets Thanks for the info. It would be great if there is a video regarding their difference so it's easier to decide which to use.
I didnt get sir when you put filter by sales person in data studio
Hello sir can you teach us that how to record in list live data in 15 min interval from stock market in Google sheet. Plz.. reply sir
Sir, With due respect, I am the biggest fan of your channel of videos. such a great video. I have a problem. I have some spreadsheets so I can't protect the passed date cell automatically. I don't use data validation. because If I use data validation then spread sheet share anybody he can change. But I am an admin/ owner. I want nobody to change the date cell. how is it possible....? Sir.. please help me 🙏🙏🙏
Awesome video, but is there a way for me, the owner of the file, to view all the data ?
@ExcelGoogleSheets
3 жыл бұрын
Yes, I'll do a video on this.
i dont want to use google data studio, is it possible to filter data in google sheet itself based on the user who has logged in. So whoever user has logged in should see data based on their email address
@ExcelGoogleSheets
Жыл бұрын
No
Brilliant. Brilliant. Brilliant. Stupid question... you used made up email addresses. Does the person viewing the GDS report have to be logged in? Cos that won't work with the dummy emails... And following on from that, could you use a different variable to filter it - some other unique thing, like the name for instance? Or am I missing the whole point? Thanks for this video it is a lifesaver already. And thanks in advance if you answer this question...
@ExcelGoogleSheets
3 жыл бұрын
Yes, they need to be logged in and their email needs to match what's in the spreadsheet.
This is valid only for gmail account?
@genysisonline8496
3 жыл бұрын
yes, only Google Account holders.
@ExcelGoogleSheets
3 жыл бұрын
doesn't have to be gmail, but needs to be a valid google account
Hi! Data Studio only add one email? maybe 2 emails in a cell separated with comma (,) or something like that
@ExcelGoogleSheets
3 жыл бұрын
According to their docs, only one email.
@ExcelGoogleSheets
3 жыл бұрын
I'll do a separate video on this.
@Samurai-Panda
3 жыл бұрын
Actually if this can be done it will be super helpful, i'm creating a report for my team and i want it to only show data for each one seperately, but i also want to use the same report so i need it to show the whole team using the same view, if that makes any sense
@nocodeexplorer
3 жыл бұрын
@@Samurai-Panda If you want the same functionality when you want change access dynamically, you can use Utilize (www.utilize.app). On Utilize you can create an app and add/remove users dynamically. Also, assign multiple users to the same row separated by commans.
Activate the SUBTITLES please
@ExcelGoogleSheets
3 жыл бұрын
I didn't even know you need to activate them. I think I just did, but their interface is weird.