Great info...thanks for digging into the "optional range" feature of connecting to the data source.

Recently i started working with looker studio and spreadsheet, this is awesome thank you :)

this was very helpful!!

17 minutes well spent.. thank you!

Super helpful, thank you!

thank you so much for the introduction 🔥

Great video, very good explanation. Thanks a lot 👍

thanks this is super helpful!

Thanks. Great content!

Time well spent. 👍

Hey JJ, thank you for the explanation. It was quite easy to understand. I am having trouble with a Google Sheet with several worksheets and formula behind it. The worksheets header does not start from 1st row of the sheet. The header of one table starts from 4th row and after 9th row there is some text and then another table and its respective header. Both tables are in same sheet. Similar tables in other worksheets as well. All the cells have different formula behind it. How can I import import such sheets in Looker studio along with its formula. Could you please help me? Thank you.

Thanks. Very helpful. How would I sort the "Transaction Date" column in your example, please?

Hey thanks for the video, I have created a dynamic database in google sheet, which everyday user input data to it. It also contain formula that I used to give label each row. Can I connect a dynamic and formula contained google sheet to looker studio?

Great Video, thank you so much. My question is, I'm creating a report for each grade level. I want the same information and just change the filter to change grade levels. what I am doing re connecting the same google sheet data for each page. Then I have to Drag and drop the fields to recreate my table and charts. Am I missing something? Each page needs a new set of data? Thank you so much..

I am trying to create a searchable company directory. I tried different controls but can't figure out how to allow the user to search without case sensitivity. Any suggestions?

Hey! Great video. I am having toubles adding data from my Sheets, since those have the data transposed, and have not found the way to make Looker Studio to take them. Any suggestions? 😅

❤❤❤❤❤❤❤❤

Hi JJ! maybe you can help me with this situation. I have problems with the data sources. I have a report for company A that pulls data from their Analytics account and a googlesheet for company-A. Today, I have "made a copy" this report (using that feature) to make a similar for company B but with the data of company B (of course ;) using a different analytics and a different googlesheet. The problem that I have now is that the report A is using the data sources of company B. Have you had this problem? How do I "unlink" this situation so they are independent regarless of the changes I do in each of them? Or how should I do this duplication process correctly? I hope my explanation was clear. thanks in advance!

Hey! Can you create a video where you show. How to take google sheets and send it looker studio and recreate the type of visual presentation you are showcasing in your cheatsheets. A step by step tutorial. Just something simple so the workflow becomes clear.

Hey man, failed to access my google sheets docs from my drive? Any help

hi, could I import more than one google sheet in one looker document? thank you.

Hi I have 3 lakh record how can I load that google sheet in gds

Does anyone have a favorite app for generating fake data?

where's waldo?