OWNER'S CREDENTIALS lets other people view or create reports that use this data without requiring them to have their own access to the data set. Credentials control who can see the data provided by this data source. Control who sees the dataĪt the top of the fields panel, you can change the data credentials. Learn more about working with data source fields. The data source fields panel is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Use standard column-row syntax to define the range: e.g., A1:Z26. Optional Range lets you define a range of cells in the selected worksheet. Learn more about filters in the Sheets Help Center. This option only applies to filters, not to filtered views. Include hidden and filtered cells lets you include or exclude this data from the data source. If this option is not selected, the field names will use the column index (A, B, C, etc.) Use first row as headers causes the data source to use the first row in your worksheet as the field names in the data source. See Create and edit data sources to learn more about configuring your data source. The data source is now connected to your data set.Īll of the columns you've included in the connection now appear as fields in the data source.Configure any of the data source options (see below).You can also paste in the URL of a Google Sheet to which you have access. You can connect to spreadsheets that you own or that have been shared with you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |