Data Studio provides two ways to limit the time frame of your charts:
- Date range properties, which only you, as an editor, can configure, and
- Date range controls, which lets report viewers control the time frame.
Here's how to work with dates and blended data:
Set the date range for individual data sources in the blend
Use the date range options for one or more of the data sources in the blend. This selects the data from this data source before it is joined with the other data sources in the blend.
To change the date range for a data source in a blend
- Edit the blended data source.
- Choose one of the component data sources.
- Configure the Date range options
- Dimension — the date dimension which controls the time frame of the data source.
- Auto — use the chart's time frame.
- Custom — override the chart's time frame. This will also override a time frame set by the date range control.
TIP: Setting the date range in the blended data source to Auto provides the most flexibility, since you can control the date range using the chart's property panel, or using a date range control :TIP
Set the date range for a chart based on a blended data source
You can apply a date range to charts based on blended data sources in the same way as charts based on a single data source. Date ranges applied to the chart act on the data after it's been blended. Custom date settings in the blended data source override the chart's settings.
Use a date range control
Date range controls let report viewers select a time frame for the report. If you've set custom date ranges for either the blended data source or the blended chart, those settings override the date range control.