date-rangecalculated-fieldlooker-studio

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


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