Substitution Parameter

Use the Substitution Parameter on a Query Form to create a parameter that can be selected or populated by the user that is completing the query form. You can configure this tool to display a pre-defined list of choices for the user to select from, or a free text area where the user can enter their own choices.

You can also use these parameters to build advanced dashboard filters; users can filter the data based on the parameter value that they selected or entered in the dashboard's query form.

Procedure

1. Drag the tool from the tool box into a query form, or select it from the Create new drop-down:

The Substitution Parameter configuration fields are displayed.

2. Populate the required fields:

3. Save your changes.

• Query Forms
  • Creating a Query Form
  • And Box
  • Column Value
  • Date Range
  • Embedded Item
  • Exclude Box
  • Header
  • Numeric Range
  • List of Values
  • Or Box
  • Parameter Box
  • Query Form Tool
  • Segment Editor
  • Sub Heading
  • Substitution Parameter
  • Use Parameter tool
  • Yes No Question