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

Google Data Studio Reports YOY

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I want to run a scorecard report that compares this month so far to the same date range the previous year. However if I compare 'This Month' to 'Previous Year', it compares the first 6 days of September 2016 to all 30 days of September 2015, so it's not a fair comparison. How do I run the report that I want?

Re: Google Data Studio Reports YOY

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
Could you do last 4 weeks vs 4weeks last year instead?

Or... just take (SeptSessions) / (6/30) to factor up for the month....
TODATE("30/" + MONTH +"/"+ YEAR, DD-MM-YYYY-, YYYY-MM-DD) - TODATE("01/" + MONTH +"/"+ YEAR, DD-MM-YYYY-, YYYY-MM-DD) +1

Also you can you GoogleSheets and add predicted data for all of Sept see this example
https://youtu.be/p941a8k2TpM?list=PLFwbZ-mNsefWTL5EFcbmXCvPizGew9Jed&t=719

Thanks

Phil.