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

Weekly timeline reports from google docs

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

I am trying to add a timeline report from Google Sheets with weeks instead of days. DS does not seem to recognise the weeks correctly. What is the exact formatting that should be used in Google Sheets for data studio to recognise week as time?

 

On Google Sheets I tried adding things like "Week 47" or the week start date but nothing seems to work, on the table report data studio will add empty weeks, show them in the wrong order or as Week NaN. The time series chart does not work at all... I can only do bar charts so far...

 

1 Expert replyverified_user
Marked as Best Answer.
Solution
Accepted by topic author Helena K
December 2016

Weekly timeline reports from google docs

Google Employee
# 2
Google Employee

Hi Helena

 

The Data Studio "canonical" date format is YYYYMMDD. You can leave your dates in Sheets in that standard date format, then use the Type drop down in the data source editor and select week format that makes the most sense (e.g. ISO Year Week or ISO Week).

 

Best!

 

Rick

Weekly timeline reports from google docs

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

This works, I was using UK data format and had tried US format but with special characters - thanks a lot!!

Weekly timeline reports from google docs

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Here's what I did to get the lines to work with missing weekly data:

 

1. Navigate to Style

2. Go to the "Missing Data" Section

3. Select "Linear Interpolation"

 

Stephen