Sometimes we may want to use one chart to show more insights or add interactivity. You can deal with this issue by creating parameters. I will use the sample superstore dataset to show how to utilize parameters to control different fields’ sort, display, and Top N. You can find the dataset on the first page of Tableau.
Step 1: Create a parameter and add all fields you want to explore
You can set any value you want, but it would be better if you filled in the correct name.
Figure 1. Chosen fields parameter configuration
Step 2: Create a calculated field and write the statement
Cause the total quantity, total sales, and average profit are the aggregated fields, we should add aggregation to the fields.
Figure 2. Chosen fields statement
Step 3: Create the Chart with the parameter
Firstly, put <State/Province> on the row’s shelf and move <Pick Measure> and <Chosen Measure> to the column’s shelf.
Secondly, Right-click <Pick Measure> and pick <Show parameter>.
Thirdly, Click the top-right drop-down button of the parameter and select Single Value (list).
Then you can switch different values in the parameter list to view their corresponding insights.
Figure 3. Chosen fields chart
Step 4: Add parameters to control the sorting
Firstly, duplicate the <Pick Measure> parameter and rename it as <Pick Sort>.
After that, create a parameter to control the ascending and descending.
Figure 4. Sorting parameter configuration
Figure 5. Ascending/Descending parameter configuration
Step 5: Create a calculated field for sorting
Figure 6. Sorting statement
Step 6: Set the sorting
Initially, right-click the <State/Province> field on the row’s shelf and select <sort>.
Additionally, sort by Field and set Field Name as <Chosen sort>.
Figure 7. Sort the chart
Step 7: Add a parameter to show Top N
Firstly, right-click the <State/Province> field on the row’s shelf and select <Filter…>.
Then select <Create a New Parameter…>.
Eventually, edit the parameter and choose any values you want for the Top N.
Figure 8. The place where you create the Top N parameter
Figure 9. Top N parameter configuration
Step 8: Go back to the page of filter and fill out the form like the below screenshot
Figure 10. Set the Top N parameter
Step 9: Show all parameters and start your exploration!
Figure 11. Final chart
If there are any problems, please feel free to point them out. Besides, you can reach out to me on LinkedIn. I will try my best to answer your questions about Tableau or Alteryx.