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

Compare previous month in Data Studio

[ Edited ]
Badged Google Partner
# 1
Badged Google Partner

I see you can set the date range for the last 30 days, but can you also apply data from previous month to get a look at how its changed?

 

Compare previous month in Data Studio

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

Hey @Luke M, if you have a "Date Range Dimension" in place, you should definitely be able to show a "Previous period" series in a time series chart.

 

More info here: https://support.google.com/datastudio/answer/6401549?hl=en

 

Do you see that "Previous period" option in your time series settings?

Re: Compare previous month in Data Studio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You can easily do it. Just create new Dimension by copying your Actual Date Column. And change the Date format to Month. USe this as a dimension in your chart.  Smiley Happy 

Re: Compare previous month in Data Studio

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I don't fully understand GDS behavior when it compares previous periods.

Why I'm having these "empty" values when I add Date dimension on a table?

 

Capture.PNG

 

Green table has delta values for every row, but rest of tables are only showing values on oldest (Date) row/s. What's the reason?

If I show Date as Auto, I even get no delta values at all.

 

I've tried to play with different date metrics, but I'm always getting same results.

I'm using a MySQL connector as a data source.

 

Thanks!