Dynamic Date Range/ On-sheet date ranges

Two Minute reports allows you to fetch data from your Data Sources for any data range that you’d like. For that we have a preset list of Date Ranges that you can select from in your Query.

Using the "Custom Range (cell reference)" date range selection, your queries can pick up the date range dynamically from your Spreadsheet. So whenever a query runs, the new date ranges from your Spreadsheet will be picked up and used to filter your data.

Once you choose the Custom Range from the Date Range drop down, you can enter spreadsheet formulas in the Start Date Cell and End Date Cell text box.

You can also click on the Reference Picker(cross-air icon) to pick up the cell reference automatically like below

This way you can quickly change your date ranges for your queries directly from your Spreadsheets.

Was this helpful?