AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

How to compare Last full Year to This Year (not to date but to last full month)?

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi all,

Is there a way I can create a chart comparing last full year users to this year, but considering only until last full month in the second one? 

In the screenshot below, you can see that the users drop dramatically in July... but just because it only counts 6 days! How do I make it display only until June?

 

Thanks

 

screen.png

How to compare Last full Year to This Year (not to date but to last full month)?

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

 I have this same issue as well.  To my knowledge there is no way this can be done through the existing date range options.  You can update the dates manually each month (do a fixed date range) but then again you need to update each month..not ideal!