Weekly timeline reports from google docs[ Edited ]
December 2016 - last edited December 2016
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...
Weekly timeline reports from google docs
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).