Last Modified Date: 07 Feb 2017
ResolutionThe below example uses Superstore sample data and filters a workbook by "Category" across all worksheets using parameters:
- Right-click in the Data window and then select Create Parameter.
- In the Create Parameter dialog box, do the following, and then click OK:
- Name the parameter. In this example, the parameter is named CategorySelect.
- For Data Type, select String.
- For Allowable values, select List.
- For List of Values, enter All, Technology, Furniture, Office Supplies.
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box, do the following and then click OK:
- Name the calculated field. In this example, the calculated field is named Matches Parameter.
- In the formula field, enter a calculation similar to the following:
[CategorySelect]="All" OR [CategorySelect]=[Category]
- Drag the newly created calculated field from the Dimensions pane to the Filter shelf.
- In the Filter dialog box, select True, and then click OK.
- On Filters, right-click Matches Parameter, and then select Apply to Worksheets > All Using This Data Source.
- Publish the workbook to Tableau Server.
- The published view can now be filtered with the parameter as a URL parameter as follows: http://<servername>/#/views/<workbook>/<sheet>?param1=value1,value2¶m2=value
- <workbook> = Superstore
- <sheet> = Performance
- ?param1 = Category
- value1 = Furniture
CauseFor more information about URL parameters, including screenshots demonstrating the URL patterns; see How View URLs Are Structured.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials