Looker Studio month v month

Looker Q&A Looker Studio
1

Hi All,

Fairly new to looker studio and need some help please.

Got a google sheet which has my data going back to 01 Jan 2020. I need it to display when I choose a date or date range for example 20 Feb 2021. I would like it to show:

20 Feb 2021 v 20 Jan 2021 v 20 Jan 2020

30 records v 25 records v 45 Records

So its showing me the current data, current data versus same date last month and also current data v same date last year.

Any guidance will be much appreciated. If there is a video on how to do this even better.

Many thanks

2

I think getting this to work dynamically in Looker Studio would be very challenging.

Instead, I’d recommend creating three separate tiles on the report, each using one of the built in filters.

3

Hi Sam,

Thanks for your reply. Are you able to please expand on that.