Google Data Studio Reports YOY
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
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