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..
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.
Thank you very much for this video - it's really helpful. Do you have any suggestions on how to share the individual reports, or do you suggest sharing a link that people can log into?
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.
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, 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 🙏🙏🙏
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!
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.
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
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
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?
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...
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
@@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.
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..
Being waiting this guide for so long... Thank your so much.. Never stop to amaze us...
Hi @muhammad. You could also achieve the same functionality on Utilize (www.utilize.app) on your mobile devices.
This blew my mind!
Thank you so much for this.
Man, ALL your vids are GOLD. thx for everything you do.
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.
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.
Thank you very much for this video - it's really helpful. Do you have any suggestions on how to share the individual reports, or do you suggest sharing a link that people can log into?
I'm not sure ho to answer that. It varies greatly depending on the situation.
That's new for me and awesome!
YOU'RE AMAZING!!!
Thanks alot
With filttering by email is it possible to give Authority to an Emil to see all records?
THank you
Awesome 👌 👏 👍 😍
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
Not entirely sure but try this Chrome Extension:
chrome.google.com/webstore/detail/data-studio-auto-refresh/inkgahcdacjcejipadnndepfllmbgoag
I think you can click on the 3 dots next to view and click refresh.
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?
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.
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.
Thank you for great video. Is there a similar way to show/hide pages for specific users?
Neat!
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 🙏🙏🙏
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!
Thanks! I am using this in the current task.
One question. Can i use Apps Script to edit share settings in Data Studio reports?
I don't think it's possible.
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.
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
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
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
No
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?
1. No. You would have to duplicated those lines.
2. For the most part, yes.
@@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.
This is valid only for gmail account?
yes, only Google Account holders.
doesn't have to be gmail, but needs to be a valid google account
Awesome video, but is there a way for me, the owner of the file, to view all the data ?
Yes, I'll do a video on this.
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...
Yes, they need to be logged in and their email needs to match what's in the spreadsheet.
Activate the SUBTITLES please
I didn't even know you need to activate them. I think I just did, but their interface is weird.
Hi! Data Studio only add one email? maybe 2 emails in a cell separated with comma (,) or something like that
According to their docs, only one email.
I'll do a separate video on this.
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
@@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.