Creating parameters in Tableau - Business Scenario Walkthrough

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants an interactive sales dashboard where users can select a sales target and see which products meet or exceed that target.

📊 Data: You have monthly sales data for different products including Product Name, Month, and Sales Amount.

🎯 Deliverable: Create a Tableau dashboard with a parameter to select a sales target and a view that highlights products meeting or exceeding that target.

Sample Data

Product Name	Month	Sales Amount
Alpha	January	1200
Beta	January	800
Gamma	January	1500
Alpha	February	1100
Beta	February	950
Gamma	February	1600
Alpha	March	1300
Beta	March	700
Gamma	March	1700

1

Step 1: Connect your sales data to Tableau and open a new worksheet.

No formula needed.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a parameter named 'Sales Target' to allow users to input a sales goal.

Right-click in Data pane > Create > Parameter. Set Data type to Integer, Current value to 1000, Allowable values to Range from 0 to 2000 with step size 100.

Expected Result

Parameter 'Sales Target' is created and visible in the Data pane.

3

Step 3: Show the 'Sales Target' parameter control on the worksheet for user interaction.

Right-click 'Sales Target' parameter > Show Parameter Control.

Expected Result

Parameter control slider or input box appears on the worksheet.

4

Step 4: Create a calculated field named 'Meets Target' to check if sales meet or exceed the selected target.

IF SUM([Sales Amount]) >= [Sales Target] THEN 'Yes' ELSE 'No' END

Expected Result

Calculated field 'Meets Target' is created and returns 'Yes' or 'No' per product.

5

Step 5: Build a view showing Product Name and total Sales Amount, and color code by 'Meets Target'.

Drag 'Product Name' to Rows, drag 'Sales Amount' to Columns (set aggregation to SUM), drag 'Meets Target' to Color on Marks card.

Expected Result

Bar chart shows total sales per product with bars colored differently for 'Yes' and 'No'.

6

Step 6: Test the parameter by changing the 'Sales Target' value and observe the color changes in the chart.

Adjust the parameter control slider or input box to different values.

Expected Result

Bars update colors dynamically to reflect which products meet or exceed the new target.

Final Result

Sales Target Parameter Dashboard

Product Name | Sales Amount | Meets Target
-----------------------------------------
Alpha        | ████████████ | Yes
Beta         | ██████       | No
Gamma        | █████████████| Yes

Parameter Control: [Sales Target: 1000]

✓Products Alpha and Gamma consistently meet or exceed sales targets above 1000.

✓Product Beta does not meet higher sales targets and may need attention.

✓The parameter allows quick comparison of products against any sales goal.

Bonus Challenge

Add a parameter to select the month and update the view to show sales and target comparison for the selected month only.

Show Hint

Create a string parameter with month names and use it in a calculated field or filter to show data for the chosen month.

Practice

1. What is the main purpose of creating a parameter in Tableau?

easy

A. To allow users to input a single value that can change calculations or filters

B. To store multiple values for grouping data

C. To create a static label on the dashboard

D. To automatically refresh data sources

Solution

1. Step 1: Understand what parameters do

   Parameters hold a single value that users can change to affect calculations or filters.

2. Step 2: Compare options with parameter purpose

   Only To allow users to input a single value that can change calculations or filters describes this interactive input feature correctly.

3. Final Answer:

   To allow users to input a single value that can change calculations or filters -> Option A

4. Quick Check:

   Parameter purpose = interactive single value input [OK]

Hint: Parameters hold one user-controlled value for interactivity [OK]

Common Mistakes:

• Thinking parameters store multiple values
• Confusing parameters with filters
• Assuming parameters refresh data automatically

2. Which of the following is the correct way to create a parameter in Tableau?

easy

A. Double-click a worksheet title

B. Drag a field to Rows shelf

C. Use the Show Me panel to add a parameter

D. Right-click in Data pane > Create > Parameter

Solution

1. Step 1: Recall Tableau parameter creation steps

   Parameters are created by right-clicking in the Data pane and selecting Create > Parameter.

2. Step 2: Eliminate incorrect options

   Dragging fields or using Show Me does not create parameters; double-clicking titles edits text.

3. Final Answer:

   Right-click in Data pane > Create > Parameter -> Option D

4. Quick Check:

   Parameter creation = right-click Data pane [OK]

Hint: Create parameters via Data pane right-click menu [OK]

Common Mistakes:

• Trying to create parameters from Show Me panel
• Dragging fields instead of creating parameters
• Editing worksheet titles instead of parameters

3. Given a parameter named Sales Threshold set to 1000, and a calculated field High Sales defined as IF [Sales] > [Sales Threshold] THEN 'Yes' ELSE 'No' END, what will be the result for a sale of 1200?

medium

A. 'Yes'

B. 'No'

C. 1200

D. Error

Solution

1. Step 1: Understand the parameter and calculation

   The parameter Sales Threshold is 1000. The calculation checks if sales are greater than this threshold.

2. Step 2: Evaluate the condition for sale of 1200

   1200 > 1000 is true, so the calculated field returns 'Yes'.

3. Final Answer:

   'Yes' -> Option A

4. Quick Check:

   1200 > 1000 = 'Yes' [OK]

Hint: Compare value to parameter in IF statement for result [OK]

Common Mistakes:

• Confusing parameter value with sales value
• Expecting numeric output instead of text
• Ignoring the IF condition logic

4. You created a parameter but the dashboard does not update when you change its value. What is the most likely reason?

medium

A. The parameter control is hidden

B. The data source is disconnected

C. The parameter is not used in any calculated field or filter

D. The parameter value is set to automatic

Solution

1. Step 1: Understand parameter behavior

   Parameters alone do not affect the dashboard unless used in calculations or filters.

2. Step 2: Identify why dashboard doesn't update

   If the parameter is unused, changing it has no effect, causing no dashboard update.

3. Final Answer:

   The parameter is not used in any calculated field or filter -> Option C

4. Quick Check:

   Unused parameter = no dashboard update [OK]

Hint: Use parameters in calculations or filters to see changes [OK]

Common Mistakes:

• Assuming parameter control visibility affects updates
• Blaming data source connection without checking parameter use
• Misunderstanding parameter value settings

5. You want to create a parameter that lets users select a discount percentage from 0% to 50% in steps of 5%. Which parameter settings should you choose?

hard

A. Data type: Boolean; Allowable values: True or False

B. Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5

C. Data type: Float; Allowable values: All; Minimum: 0; Maximum: 50

D. Data type: String; Allowable values: List; Values: '0%', '5%', '10%', ..., '50%'

Solution

1. Step 1: Determine data type and value range

   Discount percentages are numeric integers from 0 to 50 with steps of 5.

2. Step 2: Choose parameter settings matching requirements

   Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5 correctly sets integer type, range values, and step size of 5.

3. Final Answer:

   Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5 -> Option B

4. Quick Check:

   Integer range with step size = correct parameter setup [OK]

Hint: Use integer range with step size for numeric selection [OK]

Common Mistakes:

• Using string type instead of numeric for percentages
• Choosing 'All' allowable values without step size
• Using Boolean type for numeric selection