EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Parameters in Tableau

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » Tableau Tutorial » Parameters in Tableau

Parameters in Tableau

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 “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 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 that it is essential to have dynamic control for deeper analysis using 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, 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 the 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.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Below are the steps to create and use Parameters.

Step 1: First, we shall have the requisite data loaded in Tableau, as shown below:

Parameters in Tableau

Step 2: In this step, we will understand the initial few aspects of Parameters.

Parameters in Tableau

Click on this button. It will pop-up various options.

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 the “Create Parameter…” option as in the above step will generate a dialogue box, as shown below:

Parameters in Tableau

Step 4: In this step, we shall create the actual parameter. Provided name to the parameter.

Parameters in Tableau

Parameters in Tableau

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.

Popular Course in this category
Tableau Training (4 Courses, 6+ Projects)4 Online Courses | 6 Hands-on Projects | 39+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (6,121 ratings)
Course Price

View Course

Related Courses
Business Intelligence Training (12 Courses, 6+ Projects)Data Visualization Training (15 Courses, 5+ Projects)

Step 5: In this step, we will create a filter over the categorical variable, i.e. Region Name.

Parameters in Tableau

We have created a filter over the “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 filter’s previous part.

Step 6: Edit the filter to use a parameter with it.

Filters

Clicking on the button will generate various options. Click on the “Edit Filter” option. It will generate a dialogue box with various options.

Filters

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.

By field

The parameter that we created has been selected.

Here there are two options: Top and Bottom. Selecting Top will output Top performers based on “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.

By field

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.

 Parameter Control

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.

 Parameter Control

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:

 Parameter Control

Click on “Edit…”. It will generate the Edit Parameter dialogue box.

 Parameter Control

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’.

Range

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.

list

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 the requisite changes.

Range of Values

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

Range of Values

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 –

  1. Line Chart in Tableau
  2. Bubble Chart in Tableau
  3. Tableau Architecture
  4. Tableau Date Functions

Tableau Training (4 Courses, 6+ Projects)

4 Online Courses

6 Hands-on Projects

39+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Tableau Tutorial
  • Advanced
    • Tableau Reporting
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Tableau Date Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - Tableau Training (4 Courses, 6+ Projects) Learn More