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 way your metrics are visually presented in your dashboard.
Let’s say that this is your source spreadsheet:
If you decide to leave all 3 boxes unchecked, your Google Sheet widget should look like this:
If you check the Is first row header? box - Reportz will display the values from the first row as the header in your widget, which means it will be seen separately from other values, and thus displayed and manipulated differently.
In this case, your Google Sheets widget will look like this:
If you check the Is first column label? box as well, Reportz will see the first column your sheet as the label and your widget will look like this:
You can also check the Is last row footer? box, which means Reportz will treat the last row in your sheet as the footer, and your widget will look like this:
As you can see, the last row is now seen as the footer and the metrics that are in that row are not displayed in your widget.
NOTE: To use these options the right way, it is of crucial importance to organize and format the data properly in your source sheet.
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 ...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 ...What does "Is First Column Label" do in Google Sheets widgets?
When creating a Google Sheet widget, you have the option to check or uncheck "Is First Column Label". If you check it, the widget will show the data from your spreadsheet's first column. If, however, you leave it unchecked, the widget will add ...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 ...Configuring a custom subdomain for white-label reporting
Reportz allows you to set up a white-labeled version of your account on your own subdomain. If you’re not sure what white-labeling means we took this definition from Wikipedia and we couldn’t have said it better ourselves. “A white-label product is a ...