How to use Date range control in Looker Studio with Coupler.io connector?
Users can filter data using Date range control in Looker Studio with a Coupler.io connector. Make sure that you have in the source needed columns for filtering in 'Date' or 'Date range' ISO format (e.g. YYYY-MM-DD, YYYY-MM-DD HH:mm).
Note: Looker Studio charts that don't use the selected data range filter column as a dimension will be not filtered.
Configure Coupler.io connector to the Looker Studio:
- Configure Coupler.io connector to the Looker Studio. Learn how to set up Looker Studio destination.
- Configure 'Schedule' if needed
- Click the 'Save and run' button
- After the importer successfully finished click the 'Edit' button
- Click the 'Edit' button on the 'Destination'
- Click the 'Change' button on the 'Date range dimension'.
- In the drop-down 'Date range dimension' choose the parameter by which filtering will be applied.
Please note: only columns with DATE or DATETIME type will be available for selection. - Click the 'Save and run' button:
- Go to 'Looker Studio' and click the 'Connect' button.
- Ensure that the parameter has 'Date' of 'Date Time' format. Click the 'Create report' button.
- Add filtered parameter to dimension
- Open the drop-down 'Add control' and add 'Date range control'.
- Expand 'Date range control' and choose Date range, then click 'Apply'.
- Data should be filtered