Setting Up Parameters in Amazon QuickSight - Amazon QuickSight

Setting Up Parameters in Amazon QuickSight

Use the following procedure to create or edit a basic parameter.

  1. Choose an analysis to work with, and decide which field you want to parameterize.

  2. Choose the Parameters pane from the left side of the screen.

  3. Add a new parameter by choosing the add icon (+) near the top of the pane.

    Edit an existing parameter by first choosing the v-shaped icon near the parameter name and then choosing Edit parameter.

  4. The following screen appears.

    A parameter consists of the following parts, which you enter on this screen:

    Name

    Enter an alphanumeric value for the parameter Name. This name is used as a reference in the consumers of the parameters (for example, calculated field, filter, custom URL action, and so on). For ease of use, you can choose a name that reflects the data type and purpose of the parameter.

    Data type

    Choose a value for Data type. This data type can't be altered after you create the parameter. If you want to use the parameter for a text box or drop-down list, choose String.

    Values

    Choose one of the following:

    • Single value – for parameters that can contain only one value.

    • Multiple values – for parameters that can contain one or more values. Multivalue parameters can't be datetime data types. They also don't support dynamic default values.

    To switch an existing parameter between single and multiple values, delete and recreate the parameter.

    Static default value

    Choose a static default value for the parameter. This static value is used during the first page load, if a dynamic default value or URL parameter isn't provided.

    Dynamic default value

    Choose Set a dynamic default to create a default that is user-specific. A dynamic default is a per-user default value for the first page load of the dashboard. Using a dynamic default, you can create a personalized view for each user.

    Calculated fields can't be used as dynamic defaults.

    Dynamic defaults don't prevent someone from selecting a different value. If you want to also secure the data, you can add row-level locking. For more information, see Using Row-Level Security (RLS) to Restrict Access to a Dataset.

    This option only appears if you choose a single value parameter. Multivalue parameters can't have dynamic defaults.

    Note

    If you choose a multivalue parameter, the screen changes to remove the default options. Instead, you see a box with the text Enter values you want to use for this control. You can enter multiple values in this box, each on a single line. These values are used as the default selected values in the parameter control. The values here are unioned with what you choose to enter for the parameter control. For more information on parameter controls, see Parameter Controls.

    Show as blank by default

    Select this option to show the default value for multivalue lists as blank. This option only applies to multivalue parameters.

  5. Choose Create or Update to complete creating or updating the parameter.

After you create a parameter, you can use it in a variety of ways. You can create a control (such as a button) so that you can choose a value for your parameter. For more information, see the following sections.