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

Google Data Studio: Monthly comparison

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

When displaying a table of sessions per month in a period of 1 year, I would like to have a monthly comparison (previous month). It does not work because the comparison is made by data range input (1 year), instead of monthly.

 

How can I solve it?

 

 

Screen Shot 2016-11-10 at 11.46.00.pngNo comparison is available

 

Screen Shot 2016-11-10 at 11.47.49.pngset up

Google Data Studio: Monthly comparison

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi Yeray,

 

Unfortunately the current comparison periods are only 'previous period' or 'previous year' - if you are viewing your data by year you can't compare by month. This would be a great feature to see added in the future.

Re: Google Data Studio: Monthly comparison

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for your help. Hopefully this feature will be added in the future.

 

To solve it today, perhaps I can create another table to compare each month. I am trying to create a custom variable but I can't get it to work. Do you know any formula to get sessions per month and to compare it with previous month?

 

Thank you :-)

Google Data Studio: Monthly comparison

Follower ✭ ☆ ☆
# 4
Follower ✭ ☆ ☆

Just to Chime in on this one, a Monthly comparison option is something we would really like added as well.

Google Data Studio: Monthly comparison

Visitor ✭ ✭ ✭
# 5
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