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

Help with time series chart

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi there,

 

I am trying to do a REALLY basic chart in data studio but i cant seem to figure out how to get it looking exactly as I want.

Essentially I am putting in email campaign metrics from google sheets.

My columns are | post | date | number sent to | opens | clicks

 

I'd like to create a time series chart for each metric of sent to, opens, and clicks. so 3 graphs.

 

It is coming out like the below. How do I connect the dots but also keep the dates where I have no data off the chart? 

time series sent.JPG

Sorry this is really basic but I just cant figure it out!

Any help appreciated

 

Joe

 

 

 

 

 

Help with time series chart

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Are you sure you have data for each of the date points? Right now, it looks like there are only three emails, one "5 Things", one "4.1.5 Patch Info" and one "BT Award winners." Because you don't have data points every day, you might want to use months on your x-axis instead of dates. If you only have one of each item though, you're still going to get dots instead of lines. Once you build up more data, the dots will start to connect. 

 

Alternatively, if you want to connect those three dots, you can just take out the breakdown dimension that splits them into categories. 

Re: Help with time series chart

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks very much.

I'll try adding more data and also remove the breakdown dimension and see
what we get.

Cheers

Joe