Data Studio
3.7K members online now
3.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Trouble connecting different pages (from the same Google sheet) in Data Studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm just starting to configure Data Studio for my company's use, however, it seems a little buggy. I'm trying to use multiple pages within a single sheet to track my websites conversion rate.

Shown here: http://bertram.d.pr/eyr1

 

When I change the worksheet it updates all my data as if it were coming from that sheet. This seems like an obvious use case, and it might just be that I'm new to this and don't see how to fix the problem.

 

Anyone else experiencing this?

 

 

 

Trouble connecting different pages (from the same Google sheet) in Data Studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Jared,

 

I was having this same problem with adding a worksheet as a new data source. Here's how I resolved it:

 

1. Click on a chart

2. Where it says "Data Source" click on the arrow to the right, or "Select Data Source"

3. Click "CREATE NEW DATA SOURCE"

4. Find the spreadsheet you want to use.

5. Select the new worksheet you want to add as a data source.

6. Click Connect.

 

It looks like you just need to add each worksheet as a new data source - not just the spreadsheet.

 

Hope this helps!