Create a Set Parameter Data Action to Pass Static Values

You can create a Set Parameter data action when you want to assign predefined values to one or more parameters when the data action is invoked.

Unlike a Set Parameter action that passes values from selected data points, this configuration passes fixed values that you specify when creating the action. The parameter is updated with the predefined value or values regardless of which data points are selected when the action is invoked.

For example, you might have a workbook that contains an Order Priority parameter that's used to filter order data. You can create a data action named Show Critical Orders and specify Critical as the static value. When a consumer invokes the data action, perhaps with a button bar, the Order Priority parameter is set to Critical, and the workbook updates to display only critical-priority orders regardless of which data points are selected on the canvas.

Before you begin, create the parameters that you want the data action to update. Follow the steps in Create a Parameter and don’t assign an initial value.

  1. On your home page, hover over a workbook, click Actions, and select Open.
  2. In the Data panel, click Actions Data Actions icon.
  3. In the Actions pane, click Create Action.
  4. In the Name field, give your data action a meaningful name.
  5. In the Type field, select Set Parameter.
  6. In the Requires Data field, select On or Off, depending on your use case.
  7. In the Parameters section, click None, then select your parameter.
  8. In the Pass Values row, select Values.
  9. In the Values field, enter one or more values to assign to the parameter.
  10. To add another parameter, click Add Parameter and configure it as required.
  11. Click Create.