Date Range Controls

The date range control is a calendar widget that lets you adjust the timeframe of a report without editing it. This gives you a way to let your viewers to select the dates they want to see. 

In Looker Studio report Date Range control is used.

• When you have large amount of data, and in that you only need some specified data within some date range, then using Date Range Control is helpful. 

• Date Range Control helps filtering imported data.

• Use of Date Range helps in avoiding rate limiting issue on API.

• Date Range can be applied to each chart or to entire report.

• Enable edit mode for your report.

• In the toolbar, select Add a control option.

• In that dropdown select Date Range Control, and place it where you need.

• Then On the right side you get Date Range Properties panel. In that select your required start and end date or choose default date range like Last Year, Last Month etc.

• You can also customize it in look.

The date range control lets you select the dates you want. And also gives you many default options to choose. Options are like Last Year, Last Month etc to select.

When you choose connector, in report some connectors shows data automatically and some shows no data. The connectors shows data automatically use default date range of 28 days. So it takes recent 28 days data. When you see connectors with no data, you need to use data range control to see data.

We can set the timeframe to charts or reports in two ways:

• Setting the date range property for one or more components, or the current report r page. as a whole.

• Using the Date Range Control option

To add a date  range control to report, among  many data sources attached to report, at least one source must have date dimension. Because the Date range controls only affect the chart built on data source that has date dimension.

The two ways of controlling the date range in your reports are:

1. Setting the date range property for charts, the current page, or the report as a whole, and

2. Using a date range control as mentioned in Date Range Control.

To setup date ranges in your reports, you'll do the following:

• Select the chart, you want to control the date range. 

• Select the Setup tab in the properties panel.

• You will see the Default date range. In this, there are two options available 

  1.     Auto 

  2.     Custom

Auto : Gives the default as last 28 days (exclude today)

Custom: Select the date according your preferences such as Yesterday, Last 7 days (including today), Last quarter, Year to Date, and so on and click on APPLY.

For the entire report, in the menus, select File -> Report settings.

For a page, in the menus, select Page -> Current page settings.

Then:

1. On the right, in the properties panel, select the Default date range.

2. Set up the date range control using the previous instructions.