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.