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.
- Elasticsearch: Match range in list of start and end dates
- Turn a list of dates into Fridays Only
- Get date range using moment.js
- Highlight overlapping time in Google sheet for a range of data with Start and End Time in Columns
- Compute and explode a range of dates between two columns in polars
- Efficient date range overlap calculation?
- Get User total amount spent from a defined date range in WooCommerce
- Create Weekly Date Range in Excel
- Postgres split time ranges into 1 minute slots, without rounding boundaries
- Group 2d array of dates and values by contiguous dates with the same value
- Creating a new column to find the range of date
- Datetime hours range search in mongodb
- Empty dateRangeInput() is giving an error
- Iterating through a range of dates in Python
- Convert an array of datetimes into a comma-separated string of hyphenated range expressions
- Get the datetime range between two dates
- How can I turn date intervals given in columns and extract the volumes per hour in the time interval for muiltiple overlapping periods?
- pandas date_range error "ValueError: Of the three parameters: start, end, and periods, exactly two must be specified"
- Flutter syncfusion date range circle not in center
- Convert date data from a 2d array into a formatted string of dates using hyphenation to represent consecutive date ranges
- Polars: Create a new column with an array of dates from two different date columns storing the start and end of the range
- Power BI Days in a given week of a month
- Interval (days) in PostgreSQL with two parameters
- Javascript - get array of dates between 2 dates
- PHP: Return all dates between two dates in an array
- how to repeat date range Between 2 Dates via linq in vb.net
- how to query based on start and end period dates with MS ACCESS in VB.NET
- Create a Histogram based on the date range
- Simple Count of Rows that contain a date within a given Date Range
- How can I prevent dates being selected which are prior to that in another input?