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

(Google Data Studio <-> Google Sheets) Date range dimension issue

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

i'm trying to visualize a google sheet table as simple as that: http://screencast.com/t/dRiFMDhnDW

but just can't get data studio to recognize the date dimension. I tried the format solution found here without any effect.

 

On the other hand it's not a problem at all to create a chart from that data right inside of google sheets.
So it's somehow strange that data studio can't manage that. Or am i doing any stupid mistake here?

 

Thanks for your help.

 

Alex

 

 

 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Alexander F
January 2017

(Google Data Studio &lt;-&gt; Google Sheets) Date range dimension issue

Google Employee
# 2
Google Employee

Hi Alexander,

 

You need to transpose your data so that its in column format:

 

date  KPI-A KPI-B

2010   1        4

2011   2        5

2012   3        6

 

Thanks,

Dave

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Alexander F
January 2017

(Google Data Studio &lt;-&gt; Google Sheets) Date range dimension issue

Google Employee
# 2
Google Employee

Hi Alexander,

 

You need to transpose your data so that its in column format:

 

date  KPI-A KPI-B

2010   1        4

2011   2        5

2012   3        6

 

Thanks,

Dave

(Google Data Studio &lt;-&gt; Google Sheets) Date range dimension issue

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hey Dave,

 

thanks a lot. That helped.

(Google Data Studio &lt;-&gt; Google Sheets) Date range dimension issue

[ Edited ]
Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Can i replace the year by month ? like this format :

Date        KPI
January     1
February    2

Or do i need to replace each month by this format 01/01/2017 ?

I want that data studio reconize the date so i can filter ?

 

Thanks for your help 

(Google Data Studio &lt;-&gt; Google Sheets) Date range dimension issue

[ Edited ]
Follower ✭ ☆ ☆
# 5
Follower ✭ ☆ ☆

In order to use you data as "date" so GDS can recognize it, you will need to set the column in one of the following formats:

 

Screen Shot 2017-04-12 at 9.21.36 AM.png