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

Data by month in Google sheet

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello ! 

I am doing a report with data studio wich contain metrics from social media ( twitter, pinterest & instagram) i add all the metrics in google sheet by month.
For example by comumn (Date & metrics)

- December 2016 / Followers = 49500 / RT = 10 000 ...
- January 2017 / follower = 50000 / RT = 10 000 ...
- Febrery 2017 ...

I think that data studio don't reconize the date and the time when i do it by month because i can't filter by date :/ when i make the dashboard by day it's worked.

The problem is that some social media don't give me the KPI by day so i prefer to add the data month by month.

 

Do you have a solution for that issue please ?

 

Thank you 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Siham I
April 2017

Data by month in Google sheet

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Instead of writing December 2016 (which DS doesn't recognize as a date), write it as 2016-12, and edit the field type to be yearmonth.

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Siham I
April 2017

Data by month in Google sheet

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Instead of writing December 2016 (which DS doesn't recognize as a date), write it as 2016-12, and edit the field type to be yearmonth.

Data by month in Google sheet

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

This doesn't work for me. Can you share a sample data set that would build charts by month (Jan, Feb, March, etc)?

Data by month in Google sheet

Participant ✭ ✭ ☆
# 4
Participant ✭ ✭ ☆

Sorry, I mistyped, it actually shouldn't have a hyphen. It should read 20612, etc. Does that work?