Parameters are Tableau worksheet controls that affect data displayed on a worksheet. In this video, learn how to edit and delete parameters.
- Creating a parameter gives you a quick and visual way to change the characteristics of a visualization. If you decide you want to edit a parameter, you can do so with no problem. You can also delete the parameter, but be aware that means any filters or other operations based on the parameter will no longer work. I'll demonstrate how to perform these tasks in this movie. My sample file is 06 10 Managed Parameters and you can find it in the chapter six folder of the exercise files collection. In this workbook I have two worksheets I'm working on by region and you can see that I currently have a sales region parameter at the bottom and also I'm using sales region as a filter. That sales region filter is based on the value in the sales region parameter and you can see that I currently have only one value displayed Central East, which is the largest of the regions by sales. Also note that if I show these sales region parameters control that I'm not able to make any changes. So that means that I need to edit the parameter so that I can select a range of values. So I'll go to the sales region parameter spill, click it and click edit and I see that I have a list of values instead of a range of values, which is what I would need for a top filter. So I will select the range radio button and I have a range of values. So I will select the minimum. Let's say I'll set a minimum of two and a maximum of seven, right. Everything was good. I'll click okay and you'll see that the sales region parameter has changed and the minimum value of two is displayed. And if I increase the number of regions shown by sliding of the control in the parameter, then I see currently five or I can go back down to four. I can delete a parameter if I want to. Bearing in mind, as I said earlier, that doing so will break any controls, filters, that sort of thing that are based on the parameter. To delete a parameter, go to the parameter section of the data panel. Click this down arrow and click delete. When you do, you see that tablet displays a warning indicating that will affect the following sheets in this case by region. Do I want to continue? I'll say yes. That means the filter is invalid and will be removed and the action is done.
- Explain where a user would navigate to seek specific help in Tableau.
- Determine the best approach for using Excel in Tableau.
- Interpret how to use the features and functions of Tableau when creating charts.
- Describe how best to manage data in a worksheet or visualization.
- Explain how to create a selection filter for certain values.
- Explain how to manage data for different chart formats.
Skill Level Beginner
1. Introducing Tableau
2. Managing Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Creating Basic Visualizations
10. Formatting Tableau Visualizations
11. Annotating and Formatting Visualizations
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.