this was very helpful!!

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 :)

@Vision-Labs

Жыл бұрын

Great to hear!!! Love it! If you have not joined the email list & cheatsheet yet you can always do that here -> LookerStudio.VIP/KZread

Super helpful, thank you!

@Vision-Labs

Жыл бұрын

Glad I could help! - JJ

17 minutes well spent.. thank you!

@Vision-Labs

Жыл бұрын

So glad this was helpful for you! - JJ

thank you so much for the introduction 🔥

@Vision-Labs

Жыл бұрын

Of course! and if you need a deeper dive just let us know the questions you have! - JJ

Great video, very good explanation. Thanks a lot 👍

@Vision-Labs

Жыл бұрын

Thank you! -JJ

Thanks. Great content!

@Vision-Labs

Жыл бұрын

Glad we can help! - JJ

thanks this is super helpful!

@Vision-Labs

Жыл бұрын

Yay! So glad it helped you out @Matthew! - JJ

Time well spent. 👍

@Vision-Labs

Жыл бұрын

Thank you! - JJ

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

@iancarr3923

Жыл бұрын

Worked it out, thanks!

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.

@Vision-Labs

Жыл бұрын

You can use a range import and use something like C4:H which will start at C4 and take the range to H But if you have text and formatting below that it might not work. Let me know if that works! - JJ

❤❤❤❤❤❤❤❤

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?

@Vision-Labs

Жыл бұрын

Yes, you can. Shouldn't be any problems referencing a sheet containing formulas.

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..

@Vision-Labs

Жыл бұрын

I would try to put all the information into a single sheet and use filters and parameters to limit by grade or instructor etc.

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? 😅

@Vision-Labs

Жыл бұрын

Hey! What I would suggest is that you use functions in Sheets to transpose that data back in a new tab. Then connect that to looker studio. Best of luck! - JJ

@valeria-flexfire

Жыл бұрын

@@Vision-Labs but this one is a sheet that is continuously updated, any pther ideas on how to do this? Or in how to solve it on the Looker Studio side?

@Vision-Labs

Жыл бұрын

@@valeria-flexfire honestly, there are a lot of options & possibilities You could Import Range into another sheet & Trasnpose table in a different tab. Or use the Query= function Its hard to say without seeing things.

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.

@Vision-Labs

3 ай бұрын

Hey! Yeah I will try to do something here on KZread like that. Just a side note is we do this a lot in The Lab -> visionlabs.com/lab -JJ

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?

@Vision-Labs

Жыл бұрын

Hey Brittani! The easiest way is to lower case the search field ust for that chart So you can use lower(YOURFIELD) which will lowercase the directory search :) Hope that helps! -JJ

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!

@Vision-Labs

11 ай бұрын

Most likely you have a problem of the data source in Looker Studio being linked to the wrong sheet once you made a copy. Simply go into Looker Studio > Manage Data Sources > Edit connection & make sure you have the data connected to the correct sheet. Best of luck! - JJ

@milimann2739

11 ай бұрын

The issue is that when I update it to correct it, then it also updates it in the other report and I don't want that to happen.@@Vision-Labs

@Vision-Labs

11 ай бұрын

You will need to "duplicate" the Looker Studio data source as well @@milimann2739

@milimann2739

11 ай бұрын

appreciate your help. The problem was that all the data sources were set are "reusable" and you can't undo that setting unfortunately. I had to add the sources as new @@Vision-Labs

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

@Vision-Labs

Жыл бұрын

Yeah! You can have up to 50 data sources (sheets) in a single looker studio document

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

@ChotaMusonda

Жыл бұрын

It kept on telling me "spreedsheet not found" any help

@Vision-Labs

Жыл бұрын

@@ChotaMusonda if connecting to Google Sheets, try to refresh looker studio & sheets to make sure the latest version is showing up. Then make sure they are both in the same Google Account. LMK if that helps! - JJ

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

@Vision-Labs

10 ай бұрын

Hey there, I’m not 100% sure what you are asking -JJ

Does anyone have a favorite app for generating fake data?

@Vision-Labs

Жыл бұрын

A good resource for making data sets is actualy chat gpt. You can give it columns and rows to build tables for you. There will not be a ton of data, but a few dozen rows is usually enough to play with. - JJ

where's waldo?

@Vision-Labs

Жыл бұрын

Usually Waldo is hiding 🙈 -JJ