Thank you for the clean and quick walk-through. Very easy to understand. Just out of curiosity, have you been able to still get the ACL to work when you have multiple data sources? I am in a situation where I can blend multiple sources, but I have too many metrics and dimensions for the limit. Any thoughts on that?
I have a sheet with cells with hyperlinks but the hyperlinks are named so they don't show the full hyperlink, how can I get Studio to launch these still? The only way it's launching them is if I have the exact url in the cell.
Any idea how to do this for a multi-level org chart. Basically the higher you go in the company the more data they could see. I understand how to do an ACL for two levels worth of data, but once you start adding more levels it gets complicated.
Hey I want to collect result details class wise of each section in same performa with different entries in one performa multiple times. Is there any way to do this? Please help
can we do this too in Google sheets? 😭😭 I am searching for this feature. if not. Is there a way to make the auto refresh of looker studio to 1 minutes or 5 minutes?
Thanks for the video.. Accomplished exactly what my mentors asked, however they think the repetition of the emails is not elegant enough of a solution.. They proposed I used an array, but I don't see how that would work in a spreadsheet.
Maybe there is some sort of mismatch, like a space in email field. It could also happen if they have multiple google accounts and they could be logged in under the wrong account.
@@diyaaeldin Assuming emails are in column A, add a column in your spreadsheet =ARRAYFORMULA(LOWER(A2:A)) then use that column for email verification in datastudio.
How to give report access based on their roles? Like L1 employee sees their own data (~12000 employees), L2 employee should see their reporting L1 employees (~4000), L3 should see L1 & L2 reporting into them and so on
Great Video thanks for this! I did just have a quick question about the dimensions limits when you blend data? I seem to only be able to have 10 dimensions but I have some data sets with between 15-20 columns. Any suggestion here? Thank you in advance. Luke
@@anupshrestha6989 i have tinkered a lot to find a solution, end result was this, so no other solution as far as my knowledge Custom app pages might help, i thing that’s a good topic for new video series
If you can't wait 15 minutes then I'm afraid you're either going to have to build your own system for reporting or create a bot that will click on refresh button on your editor account every minute or something.
Very helpful and nice explanation
Is it possible to create an access for manager to see all the data of their employees while employees can only the data they have access over?
This is so affective for a multirole company like mine... 👍
Thank you for the clean and quick walk-through. Very easy to understand. Just out of curiosity, have you been able to still get the ACL to work when you have multiple data sources? I am in a situation where I can blend multiple sources, but I have too many metrics and dimensions for the limit. Any thoughts on that?
I have a sheet with cells with hyperlinks but the hyperlinks are named so they don't show the full hyperlink, how can I get Studio to launch these still? The only way it's launching them is if I have the exact url in the cell.
This is great, Excellent video, Thanks!
Any idea how to do this for a multi-level org chart. Basically the higher you go in the company the more data they could see. I understand how to do an ACL for two levels worth of data, but once you start adding more levels it gets complicated.
It would have helped if you had the link to the previous video in description
Awesome, this is what expected
Very good! Question! This works with other e-mails providers (not gmail)?!
Hey I want to collect result details class wise of each section in same performa with different entries in one performa multiple times. Is there any way to do this? Please help
can we do this too in Google sheets? 😭😭
I am searching for this feature.
if not. Is there a way to make the auto refresh of looker studio to 1 minutes or 5 minutes?
Can you do this without emails and just passwords? For each page?
As always, amazing content
Much appreciated!
Nice, let me try at my google studio 👍
Thanks for the video.. Accomplished exactly what my mentors asked, however they think the repetition of the emails is not elegant enough of a solution.. They proposed I used an array, but I don't see how that would work in a spreadsheet.
Nigher do I. But then people say one thing but it turns out them mean something completely different.
Hi - can you share a link to the previous video you mention right at the start? Thanks!
ua-cam.com/video/VV8uiG5HXPQ/v-deo.html
great♥
some of my customers by email they receive an empty tables!!!
Do you have idea how can I fix this?
Maybe there is some sort of mismatch, like a space in email field. It could also happen if they have multiple google accounts and they could be logged in under the wrong account.
@@ExcelGoogleSheets thank you for your prompt reply, I note sometimes when there is an uppercase letters in the email it isn't work!
@@diyaaeldin Assuming emails are in column A, add a column in your spreadsheet =ARRAYFORMULA(LOWER(A2:A))
then use that column for email verification in datastudio.
How can i link multiple email-ids of the same person with his unique data Can you help me please?
Thank you for posting! This is easy to follow & replicate.
Thank you so much for this video. I am so happy I've found your channel 👍👍
Welcome!
How to give report access based on their roles? Like L1 employee sees their own data (~12000 employees), L2 employee should see their reporting L1 employees (~4000), L3 should see L1 & L2 reporting into them and so on
hi, thanks for your video, awesome job! I tried to use it for piechart but somehow it does not work, but works well for table, do you know why?
That's weird, I don't know, it shouldn't matter.
@@ExcelGoogleSheets found out the problem, it worked, thank you
Great Video thanks for this!
I did just have a quick question about the dimensions limits when you blend data?
I seem to only be able to have 10 dimensions but I have some data sets with between 15-20 columns. Any suggestion here? Thank you in advance. Luke
Users cant refresh the datastudio any solution ?
Give them edit right and ask them to refresh data as shown at the end of this video
@@divi12345 if i grant edit permission to user the can edit settings or setup ... So any other way to handle this.
@@anupshrestha6989 i have tinkered a lot to find a solution, end result was this, so no other solution as far as my knowledge
Custom app pages might help, i thing that’s a good topic for new video series
@Do Viet what about instant refresh if user wants to update and check the data... We cannot wait for 15 mins to see a data in datastudio.
If you can't wait 15 minutes then I'm afraid you're either going to have to build your own system for reporting or create a bot that will click on refresh button on your editor account every minute or something.
hey Dear teacher can you Post Google Locker/Studio Tutorial Like You Do AbouT Google Sheet And Excel
It is free or paid??