![]() Report viewers don't see it.Ĭhanging the Parameter ID will break components and calculated fields that include the parameter.ĭata type: parameters can store text, numbers, or Boolean (true/false) values. The parameter ID is used internally by Looker Studio to identify the parameter. This is also the name you'll use to refer to the parameter in a calculated field. Parameter name: you'll see this name in the lists of available fields in your reports and data sources. For BigQuery connector and community connector parameters, see the articles referenced above. Use these options to configure a parameter in the data source. Make any changes, then in the bottom right, click SAVE.Click the sign to the right of the parameter name.Locate the parameter in the field list.Edit the data source that contains the parameter.To change the configuration of an existing parameter: You'll need to reconnect the data source to see any new, removed, or changed parameters Edit an existing parameter Once you've created a data source from a community connector, changes to the parameters in that connector won't appear in the data source automatically. Use the Allow to be modified in reports checkboxes to allow or disallow editing the parameter in reports.Connectors that allow you to define custom parameters will include instructions on the page. If the connector provides editable parameters, they appear at the bottom of the page.In the top left, click EDIT CONNECTION.If you can edit the connection for a data source built with a Community connector, you can specify which parameters report editors can change: Parameters and Community connectorsĬommunity connector can include overridable parameters, which let report editors modify their default values in a data source. The BigQuery connector defines several standard parameters that pass the report's start and end date, and the user's email address, if available. You can pass parameters to a custom SQL query in the BigQuery connector. While editing a report, you can use the +Add a parameter link in the data panel to create a parameter in the selected data source. Configure the parameter's options and default value (see below).Be sure to select a component based on the desired data source. You can also create a parameter while editing a report by selecting a component, then in the bottom right, clicking ADD A PARAMETER. In the upper right, click ADD A PARAMETER.You can create parameters in the following places: In a data source For example, an account number parameter, or name of a database table would potentially return data you didn't intend to share, or perhaps return a different schema, which might be incompatible with existing charts in the report. Other parameters, however, might allow someone to request entirely new data sets. Some parameters may only return relatively "safe" data, like weather in a new locale. Before you enable parameters for your data source, be sure you understand how changes to parameter values could affect the data in your reports. Parameters let report editors request data that differs from the default. How parameters share your data in reportsĮditors of your reports and data sources can access any data that is controlled by parameters. You'll find parameters at the bottom of the field lists in the report and data source editors. From a default value defined for the parameter.Parameters can get their data from the following places: You can pass parameters back to a community connector.You can pass parameters back to the custom SQL query in a BigQuery data source.You can use parameters in calculated fields to display results based on user input.Parameters act like variables in a programming language.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |