How to Set Google Sheets Dashboards to Filter your Metrics by Date Range
When connecting Google Sheets dashboards to Reportz, you have the option to filter your metrics by the date range of the dashboard.
To do this, you need to format your spreadsheets in such a way so the dates are inserted in the first column (A) of the rows you want to show.
See screenshot below:
One other thing to have in mind is that the label (B) column must always have unique values.
How to Configure Google Sheet Widget for this Purpose
During the process of creating a widget within which you want to show data from a particular date range, make sure you tick the following boxes:
Is first row header?
Is first column label?
Should we apply date range when fetching rows?
See screenshot below:
After this, simply choose the metrics you want to show in your report, and create your widget.
The best way you can set up your Google Sheets spreadsheet is by checking out our Reportz Template for Google Sheet & creating a copy of it for your Google Account.
Related Articles
How to Add a Google Sheets Widget
Importing your Google Sheets spreadsheets into Reportz is a simple process and it only takes a couple of clicks. To create your Google Sheets widget, you should follow these steps: 1. Click on ADD DATA WIDGET, select Google Sheets as your Integration ...Difference Between Chart Date Range & Dashboard Date Range?
The industry standard dictates that graphs within all widgets show the metrics for the last 12 months by default. Although the number on the top of your widget may show the date range you’ve chosen, the chart will always display the data from the ...How to Use our Google Sheets Template Spreadsheet
You can access our Reportz template for Google Sheets here. Important notice: This template should only be used if you would like the data in your report to be changed as you’re changing the date range of your dashboards. If you wish to present data ...How and where to set date and date-range on your dashboard
Before we tell you how you can set your wanted date range in Reportz, you should know that the date range can be changed in both Edit mode and Reporting mode of your dashboard. The date range you set up in Edit mode is the date range that will be ...Google Sheets: What are Header/Footer/Column Label Options For?
When creating your Google Sheets widget in Reportz, after choosing the Custom type of widget, there’s an option to check or uncheck the following questions: Is first row header? Is first column label? Is last row footer? These options can affect the ...