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

Google Data Studio not pulling data from connected Google Sheet

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Does Google Data Studio have a way to just bring a number in a cell over from a linked Google Sheet?

 

April 24, the number will be 40

April 25, the number will be 41

April 26, the number may be 40 or 42

 

I have row A set as column names and column 1 set as date following the format YYYY-MM-DD (in Google Sheets I don't see a date format of YYYYMMDD without the dashes). That part seems to work. But as soon as I try to bring the numerical data over that is in the table, GDS can only give me the count (number representing how many entries I have), sum of all numbers in that column, average of all numbers, max of all numbers, min of all numbers, but never the number itself.

 

I even thought to input the numerical field from as text (since I just need the value), but that changes the value from a metric to a dimension and then I can't use the value.

 

 

Google Data Studio not pulling data from connected Google Sheet

[ Edited ]
Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Rotate D

 

I have done something similar to pull through a daily budget number, linked on date - I believe this may give you what your looking for, here's a link to my blog post walk through:

http://singularbean.co.uk/bullet-charts-with-a-dynamic-goal-in-google-data-studio/

 

In this example it's a bar chart, but you can pull this number through in a scorecard if you prefer and it will work just fine.

 

Hope that helps,
Ben