Excellent! I've used this a couple years ago with Google analytics data. The interface seems cleaner and more responsive than what I remember. I'll check it out. Thanks!
Me has convencido para usar en mis reportes de trabajo usar looker o google data studio tiene una mejor vision y presentacion gracias por el video megalike sigue subiendo mas material de looker. Saludos.
Thank you very much for this excellent video ! I would be interested in creating graphics (bar/ pie charts for example) of the data in the pivot tables so that they appear in the same Looker report. Thank you.
Instead of a Grand Total Row at the bottom, is there a way to display average for each region? For example NorthEast $982k divided by number of years and every time number from 2022 changes, it will reflect on our formula as well?
Hey if i want to break the data like one customer purchased many items can i put customer name in dimension and in drilldown can i put item purchased as one customer can purchase many items
Thanks again for your efforts to educate followers about helpful tools. I thought this particular tool would be helpful to me however I've discovered a problem when sharing a report using the "Viewer" option. The report used a date range control object which evidently would not filter the data in the report tables. I tested various ways, including granting Editor permissions, and never could get the data to filter using any selected date range from the test account. I should probably report this but haven't the time to focus on it.
@@ExcelGoogleSheets The report contains two charts (table format), each using the one date column in the dataset. The date range control evidently uses that single date column because there isn't an option to attach manually that I can see. In edit and view mode in my account where the report was developed everything works. In the test account it did not when the link was sent via email from the Share screen. However, I just tested again by simply copying the link and accessing the report in the test account browser...and it works perfectly. Why this happened I can't explain but nothing in the report had been changed. In any case it works in the test account and I'm satisfied it will be useful to utilize the tool. Again, thanks so much for your attention to this matter. You're so helpful!
Thanks for this video. How to show ... 1) How many days has past from the month and 2) How many days are remaining from the month. The value should change automatically as per todays date. I have tried to search eomonth function in the calculated field but no use. Your help will be apreciated. 🙏
CURRENT_DATE DATETIME_ADD DATE MONTH YEAR That would require a combination of the functions above. The logic would be to get the first day of next month and subtract one day. Or you can do the math in the source spreadsheet.
Sir I know this not right video to put this question but please let me know how can we paste data from sheet 1 to sheet 2 but condition is that col1 data from sheet 1 pasted in col1 of sheet2 but col2 data from sheet 1 pasted in column 3 of sheet2...And going on col3 data from sheet 1 pasted in col5 in sheet2. Please give your thought about that also
Exploring Looker Studio further I have an issue with formatting numbers, specifically currency format that truncates trailing decimals if the value is zero, e.g. $99.99 displays okay but a value like $99.90 displays as $99.9 in the report. I noticed a number of currency values in this tutorial that displayed the same way, but nothing was mentioned about it. I've spent too much time searching Looker Studio documentation and forums with no solution. Am I missing something? Is it acceptable to display U.S. currency this way? Is there a function such as CURRENCY() that can be used in a created metric field?😵💫
Can you do a video on how to do Excel 2021 without LAMBDA helper functions? I want to know what is the Excel 2021 equivalent of the formula being used: =ARRAYFORMULA(IFERROR(SUM(IF(BYROW(FILTER(Ballots!$C$2:$T$1001,ISNA(XMATCH(Ballots!$C$1:$T$1,$B$39:B$39))),LAMBDA(x,IFERROR(INDEX(FILTER(Ballots!$C$1:$T$1,ISNA(XMATCH(Ballots!$C$1:$T$1,$B$39:B$39))),XMATCH(MIN(x),x)),"|")))=$B2,1,0)),0)) Also, how can I transform from Google Sheets to Excel 2021 if there is ARRAYFORMULA and ARRAY_CONSTRAIN? I don't have Office 365 as of now.
I don't think you can do an array equivalent for this prior to BYROW LAMBDA. Maybe some weird & complicated MMULT, but I'm not even sure without giving it a try. But in general equivalent to ARRAYFORMULA would be to press ctrl+shift+enter to apply the formula.
Thx a lot, my friend!
You are perfect teacher, so easy to learn with you.
Keep going!
Great explanation! And it's timeless too... Thank you for your clear English + your voice and of course the clearly conveyed content 🫡
Brilliant presentation from an exceptionally sharp mind. I can't thank you enough for the invaluable impact this has made on me
Thank you very much, Sir. Your videos are very helpful to me in my office job... I learned a lot...
Excellent! I've used this a couple years ago with Google analytics data. The interface seems cleaner and more responsive than what I remember. I'll check it out. Thanks!
Me has convencido para usar en mis reportes de trabajo usar looker o google data studio tiene una mejor vision y presentacion gracias por el video megalike sigue subiendo mas material de looker. Saludos.
I love your channel!
The value you bring to us on every video it's amazing!
Would be cool if we can reach to you on linkedin
Year after year always very useful, thanks!
🙂
great video. Thank you very much. Keep it going!
Expecting more Data Blending in Looker Studio using Google Sheets 🤞
Thank you sooo much for this video. Very helpful..
😊
Excellent presentation.
Thank you!
Very well explained, thanks 👍
🙂
Thanks for a good video!
Thank you very much for this excellent video ! I would be interested in creating graphics (bar/ pie charts for example) of the data in the pivot tables so that they appear in the same Looker report. Thank you.
many thanks for explanator
is possible download file so i can practice ?
thanks Alberto
Thanks a lot
Instead of a Grand Total Row at the bottom, is there a way to display average for each region? For example NorthEast $982k divided by number of years and every time number from 2022 changes, it will reflect on our formula as well?
Hey if i want to break the data like one customer purchased many items can i put customer name in dimension and in drilldown can i put item purchased as one customer can purchase many items
Thanks again for your efforts to educate followers about helpful tools. I thought this particular tool would be helpful to me however I've discovered a problem when sharing a report using the "Viewer" option. The report used a date range control object which evidently would not filter the data in the report tables. I tested various ways, including granting Editor permissions, and never could get the data to filter using any selected date range from the test account. I should probably report this but haven't the time to focus on it.
I use data range control and it works fine for me.
Are you sure your date column was selected as the data range dimension?
@@ExcelGoogleSheets The report contains two charts (table format), each using the one date column in the dataset. The date range control evidently uses that single date column because there isn't an option to attach manually that I can see. In edit and view mode in my account where the report was developed everything works. In the test account it did not when the link was sent via email from the Share screen. However, I just tested again by simply copying the link and accessing the report in the test account browser...and it works perfectly. Why this happened I can't explain but nothing in the report had been changed. In any case it works in the test account and I'm satisfied it will be useful to utilize the tool. Again, thanks so much for your attention to this matter. You're so helpful!
How can we add matrix for calculating XIRR for group total
why dont i see column and row dimension option in my setup panel? I just see dimension
how can i get these datasets please?
Thanks for this video. How to show ... 1) How many days has past from the month and 2) How many days are remaining from the month. The value should change automatically as per todays date. I have tried to search eomonth function in the calculated field but no use. Your help will be apreciated. 🙏
CURRENT_DATE
DATETIME_ADD
DATE
MONTH
YEAR
That would require a combination of the functions above.
The logic would be to get the first day of next month and subtract one day.
Or you can do the math in the source spreadsheet.
Hi!
I wasn't able to see the optional metric button eventho the formula I've added was accepted
It's ok now. I had the chart header on "do not show"
👍
Is it possible to import a pivot table available in data studio to google sheets?
No.
Sir I know this not right video to put this question but please let me know how can we paste data from sheet 1 to sheet 2 but condition is that col1 data from sheet 1 pasted in col1 of sheet2 but col2 data from sheet 1 pasted in column 3 of sheet2...And going on col3 data from sheet 1 pasted in col5 in sheet2. Please give your thought about that also
Maybe copy and paste each column separately?
Hello, I am following your channel with great interest.
Is this google data studio paid?
No.
Exploring Looker Studio further I have an issue with formatting numbers, specifically currency format that truncates trailing decimals if the value is zero, e.g. $99.99 displays okay but a value like $99.90 displays as $99.9 in the report. I noticed a number of currency values in this tutorial that displayed the same way, but nothing was mentioned about it. I've spent too much time searching Looker Studio documentation and forums with no solution. Am I missing something? Is it acceptable to display U.S. currency this way? Is there a function such as CURRENCY() that can be used in a created metric field?😵💫
Under Style Change Decimal Precision to 2.
@@ExcelGoogleSheets 👍
Let's be honest, it's a stupid way of handling this. But hey, it works.
sir once the user aceess is only viewer. They can't refresh data :(
The refresh data function only available to the user with edit access.
You can set the report to auto-refresh the data every 15 minutes.
support.google.com/looker-studio/answer/7020039?hl=en#zippy=%2Cin-this-article
Can Google Sheets also do calculated fields?
Yes ruclips.net/video/pdLl5IL-ZGY/видео.html
33:00
Can you do a video on how to do Excel 2021 without LAMBDA helper functions? I want to know what is the Excel 2021 equivalent of the formula being used:
=ARRAYFORMULA(IFERROR(SUM(IF(BYROW(FILTER(Ballots!$C$2:$T$1001,ISNA(XMATCH(Ballots!$C$1:$T$1,$B$39:B$39))),LAMBDA(x,IFERROR(INDEX(FILTER(Ballots!$C$1:$T$1,ISNA(XMATCH(Ballots!$C$1:$T$1,$B$39:B$39))),XMATCH(MIN(x),x)),"|")))=$B2,1,0)),0))
Also, how can I transform from Google Sheets to Excel 2021 if there is ARRAYFORMULA and ARRAY_CONSTRAIN? I don't have Office 365 as of now.
I don't think you can do an array equivalent for this prior to BYROW LAMBDA. Maybe some weird & complicated MMULT, but I'm not even sure without giving it a try.
But in general equivalent to ARRAYFORMULA would be to press ctrl+shift+enter to apply the formula.
It's very likely that instead of doing everything in one cell, you'll need multi-formula approach.
@@ExcelGoogleSheets Hoping for a video on that.
Very useful guide, thanks for the video