Introduction to Parameters in Tableau
The variable that assumes no particular value but takes a value as passed or assigned by the user based on the context is termed as “parameter” in general. In Tableau, parameters are similar entities that take context-based values and offer dynamism to the user. Let us take an example. The senior management in an organization likes to see a certain number of top and bottom performing regions, in terms of sales, at the end of every month. In their dashboard, they have provided to visualize the first top ten performing regions. However, the management now feels, for deeper analysis, it is essential to have dynamic control by means of which any number of top performers can be viewed over the dashboard. In Tableau, this can be achieved using “parameters”.
How to Create and Use Parameters in Tableau?
Now, we shall see, step-by-step, as to how to create and use parameters. Using parameters, we are going to display the requisite number of top-performing regions. For this example, we are going to use data that has multiple fields. Each field has significance of its own. For our purpose, the fields that are of interest are Region and Quantity. The region is a categorical variable, while Quantity is a numerical variable.
Below are the steps to create and use Parameters.
Step 1: First, we shall have the requisite data loaded in Tableau as shown below:
Step 2: In this step, we are going to understand the initial few aspects pertaining to Parameters.
Click on this button. It will pop-up various options.
Clicking on the button will generate a list of menus. Click on the “Create Parameter…” option from the list.
Step 3: Clicking on “Create Parameter…” option as in the above step will generate a dialogue box as shown below:
Step 4: In this step, we shall create the actual parameter. Provided name to the parameter.
A newly created parameter appears in the lower-left corner of the window. It appears under the “Parameters” section just below the “Measures”. It is highlighted for easy noticing. Now, we will use this parameter in the filter to serve our purpose.
4.5 (5,433 ratings)
View Course
Step 5: In this step, we will create a filter over the categorical variable i.e. Region Name.
We have created filter over “Region Name” field by bringing the dimension in the “Filters”
section. Next, we will use the parameter “First Top N” that we created in the previous part with
the filter.
Step 6: Edit the filter to use a parameter with it.
Clicking on the button will generate various options. Click on the “Edit Filter” option. It will generate a dialogue box with various options
In the dialogue box, click on the “Top” tab. By default “None” is selected. Click on “By field”. Clicking on “By field”
activates these options. Here the default value is 10. Notice, the parameters that we created appeared on the list. Click on that and select it.
The parameter that we created has been selected.
Here there are two options: Top and Bottom. Selecting Top will output Top performers on the basis of “Quantity” using the “First Top N” parameter. Selecting Bottom shall do the reverse. Finally, Click on “Apply” and then on “OK”
Step 7: We will make the parameter visible on the window without which it won’t be possible to make its use.
Select the “Show Parameter Control” option from the list. It will make the parameter visible on the screen. Right-Clicking on the parameter will generate a list of menus.
Clicking on “Show Parameter Control” makes the Parameter visible. Remember, we had set the default value to 5 while creating the parameter. The graph now has only 5 bars corresponding to the first 5 top
performing regions.
Step 8: Validating and using the parameter, experimenting with multiple values.
Entering ‘3’ here has given us the first top 3 performing regions in terms of quantity sold. The top three performing regions generated after we entered the requisite parameter value. Parameters enable real-time value assignment
and facilitate dynamism to the user.
In the above part, we learned to create and use the parameter. In this case, we allowed the
parameter to take any value by selecting “All” in “Allowable values”. Now, we will try to explore
the other two options viz. List and Range.
Allowable values as a list
Right Click on the parameter and click on “Edit…” as shown:
Click on “Edit…”. It will generate the Edit Parameter dialogue box.
Select the “List” option. In the “List of Values” section, we have created a list containing values 3, 5, and 10 with Top 3, Top 5 and Top 10 as their respective names. Once done, click on ‘OK’.
See how the list appears now. It appears as a list. Now parameter can only take a value amongst those specified in the list. It will display the result accordingly.
Click on the parameter to explore various options. We can change the way we want to display the list by selecting a suitable option.
Allowable values as Range
Again, edit the parameter as mentioned in the above section and perform requisite changes.
Select the “Range” option. Set the minimum and maximum values. We have set the minimum value to 3 and the maximum to 10. Click OK, once done
Notice, now parameter appears as a slider which can take values ranging from 3 to 10. We have selected 7 as the
parameter value as a result of which we got the top 7 performers in the output.
Conclusion – Parameters in Tableau
Parameters are dynamic entities that add tremendous value to Tableau as a functionality. They can be used in multiple ways based on the context. The basic idea underlying parameters in Tableau remains the same as that of any parameter in general that they are not constant but assumes any value assigned to them in real-time.
Recommended Article
This is a Guide to Parameters in Tableau. Here we discuss Introduction to parameters in tableau and how to Create and Use parameters respectively. You can also go through our other suggested articles to learn more –