How to create a 'past 3 months' time period in Google Data Studio

Issue

I’m trying to have my line chart show data for the past 3 months. GDS has a ‘last quarter’ date range, but this shows me Q1, Q2, Q3, or Q4. What I need is the data for the past 3 full months (not counting the current month). I tried creating a calculated field but the documentation isn’t proving very useful for the matter at hand.

eg. If the current date is Feb-20, I want to show data from ‘Nov 1 – Jan 31’. Also need to compare to same period from last year.

Can anyone help? Thanks in advance!

Solution

You can use the option “advanced” in the date dropdown and set the start date to today minus 3 months.

enter image description here

Answered By – Zappageck

Answer Checked By – Robin (AngularFixing Admin)

Leave a Reply

Your email address will not be published.