(1.1.1.태.0) Create Parameter

One of the English Proficiency Improvement schemes for teaching Tableau in English

 

Today topic is one of the major features in the mid-level range of Tableau, 'Create Parameter'

 

Belows are excerpt from https://help.tableau.com/current/pro/desktop/ko-kr/parameters_create.htm

 

Parameter is a global placeholder value such as a number, date or string that can replace a constant value in a calculation, filter, or reference line.

 

Create Parameter

 

Follow the instructions below to create a new parameter from Data pane.

 

1. In the Data pane, click the drop-down arrow in the upper right corner and select Create Parameter.

 

2. In the Create Parameter dialog box, give the field a Name.

 

3. Specify the data type for the values it will accept :

 

4. Specify a current value. 

 

5. Specify the display format to use in the parameter control (Tableau Desktop)

 

6. Specify how the parameter will accept values. You can select from the following options :

 

* All - The parameter control is a simple text field.

* List - The parameter control provides a list of possible values for you to select from.

* Range - The parameter control lets you select values within a specified range.

 

The availability of these options is determined by the data type. For exmaple, a string parameter can only accept all values or a list. It does not support a range.

 

If you select list, you must specify the list of values. Click in the left column to type your list of values, or you can add member of a filed by selecting Add values from.

 

If you select Range, you must specify a minimum, maximum, and step size. For exmaple, you can define a date range between January 1, 2019 and December 31, 2019, with the step size set to 1 month to create a parameter control that lets you select each month in 2019.

 

In this case, to refresh the parameter's list of values (or domain) whenever the workbook opens, select List, and then select When workbook opens. Notice that the list of values on the left is grayed out because the workbook is dynamically pulling values from the data source.

 

7. When is finished, click OK.

 

The parameter is now listed in the Parameter section at the bottom of the Data pane. 

 

The parameter is also available everywhere else you can use a parameter - for example, on the Top tab in the Filter dialog box, or in the Reference Line dialog box. Parameters are global across the workbook and can be used in any worksheet.