The Change Set Values Action allows you to select, visually, the values to put in a Set. From one or multiple Source Worksheets, you can update the values of a Set in your data source to impact other visualizations in your Workbook.
When you create a Change Set Values Action, a configuration window opens where you can specify the following:
- The Name of the Action
- The Source Sheets
- The trigger (Hover, Select, or Menu)
- The Set—you have to specify the Data Source and the Set
As for the Action Filter, you can dictate the behavior when clearing the Action. There are three different behaviors:
- Keep set value: When you clear the selection, the current values of the Set stays as selected
- Add all values to set: When you clear ...
