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

y-axis on time series doesn't show values of metric

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

i can only get the data to show when it's in a bar chart, not a time series. 

i've tried changing the formats and everything i can think of. 

 

here's how it's set up in Sheets

data.jpg

dataStudio.jpg

here's the report from DS. 

report.jpg

Re: y-axis on time series doesn't show values of metric

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I think it's likely the date that's the problem. Data Studio has trouble reading dates in the format 1/1/17. Try changing them up so that it reads 20170101, then set the date type in DS as YYYYMMDD instead of YYYYMM.

 

Once you do that, there will be a date dimension option underneath your data source. Once you add that, it should map better on the line chart. You'll likely want to set up a calculated field in DS so that you can map the line chart by month instead of date.

date.JPG