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

Google Sheet Date and Data Studio report

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

I use a Google Sheet as a source data for a Data Studio Report and the date format that show up is a number. I did not find a way to convert to  "dd/mm/yy" format. The dates are in yyyy/mm/dd in data source.

 

 

 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Solange I
May

Google Sheet Date and Data Studio report

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Screen shots of  your source and Data Studio Report would be helpful so we can see.

 

You can also take a peak at https://support.google.com/datastudio/answer/6401549?hl=en

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Solange I
May

Google Sheet Date and Data Studio report

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Screen shots of  your source and Data Studio Report would be helpful so we can see.

 

You can also take a peak at https://support.google.com/datastudio/answer/6401549?hl=en

Re: Google Sheet Date and Data Studio report

Top Contributor
# 3
Top Contributor

You can also modify your Sheet to include a date column that's adapted to the DS format; see attached below

Screenshot 2017-05-19 13.51.03.png

 

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan