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

Date Selection Last 12 Months Compared to Previous

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hi everyone,

 

I have a report created for Jan 2018. Under the monthly metrics I have a card to show a monthly historial breakdown. Currently it's set to Last Year vs Previous Period. So, the chart goes to Dec 2017, and doesn't include the current month.

 

What I really want is to show Jan 2017 to Jan 2018 vs Previous Period (yes, 13 months, but I'll settle for 12 if I have to).  However, this isn't working. In addition, because it's custom (if I get it to work) does this mean I have to manually adjust the date range to consider Feb 18 when the new reports are due?

 

I hope this makes sense....

 

Thanks!

Date Selection Last 12 Months Compared to Previous

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

What do you mean when you say last year vs previous period does not work? I.e. what is the error and can you provide a screenshot?

 

I don’t think you can set a default date range for the last X months at this time though. So I think you will need to update the default range every once in awhile if you use a custom date range. 

Date Selection Last 12 Months Compared to Previous

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

Sorry, I did mean the last 13 months vs the previous 13.

 

I do think as well, like you said, if it is custom i'd have to update.....