Update Variable

Use this action to change the value of a variable in the dashboard.

Usage Example

As an example, consider a dashboard that displays a product price after applying a discount.

1. Two Input Value variables are added to the dashboard: Discount and Discounted Price. The default value for Discount is 10, and for Discounted Price it is 0.
2. Three widgets are added to the view: Parameter, Text, and Table.
3. The Parameter widget displays the value of the Discount variable.
4. The Text widget displays the value of the Discounted Price variable.
5. The table shows product names and their prices. The Unit Price dimension has the Update Variable click action assigned.
6. In the click action settings, the Discounted Price variable is selected.
7. The Discounted Price variable is updated using the formula: "product"."Unit Price" * (1 - ${Discount (%)}/100).
8. To trigger the click action immediately upon clicking a product price, table filtering is disabled.
9. Configuration is complete. Publish the dashboard. Set an arbitrary discount size, for example, 25%, and click any product price to execute the click action.
10. The Discounted Price variable updates.

Click Action in YAML

To add a click action (UPDATE_VARIABLE), use the keys listed in the table. Specify these keys within the onClick block. Keys for the onClick block are described on the page Click Actions.

Use the name and inputMethod keys inside the variables block. Example:

onClick:
  - type: UPDATE_VARIABLE
    name: Update Variable
    variables:
      - inputMethod: FORMULA
        formula: '"product"."Unit Price" * (1 - ${Discount (%)}/100)'
        name: Discounted Price