- Action are something which perform some activity when u trigger some event.
- Earlier Action Are basically 3 types:
1-Action on Filter
2-Action on the URL
3-Action on the Highlight
- But now in new version there are different ways:
Filter actions send information between worksheets & Dashboard. A filter action sends information from a selected mark to another sheet showing related information. Behind the scenes, filter actions send data values from the relevant source fields as filters to the target sheet.
For example, in a view showing the category of sales product, when you select a particular category, a filter action can show all comparable category in a different view.
Just I create one bar graph in a one sheet and its take the action on second sheet. For taking a action we have to create a action : For first step go to worksheet then use a filter and then continue
In the Actions dialog box, click Add Action, and then select Filter. Or select an existing action, and choose Edit.
Once you done with this step then you can use a multiple option to select your action where you want to reflect your action: like
This is my second created sheet and all action we can on this second sheet2 which is sub-category:
Now my target is once I select in sheet1 any category like furniture and it will give only give the output of all sub-category of furniture in sheet2.
Let’s suppose I am selecting furniture from first sheet and its perform the action all furniture sub-category on second sheet.
If I select 2 category it will shown second sheet with 2 sub-category:
Activity on second sheet2:
Understanding available target fields
dialog box in the add filter, the fields available in the Target Field drop-down list are limited to the data type of the Source Field. For example, if you select a furniture field for the source, only furniture fields are available as targets. When using a multidimensional data source, the destination sheet must use the same data source as the source sheet, and the source and target field names must match. (In Tableau, multidimensional data sources are supported only in Windows.)