Bird
Raised Fist0
Tableaubi_tool~8 mins

Parameter in calculated fields in Tableau - Dashboard Guide

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Dashboard Mode - Parameter in calculated fields
Business Question

How can we use a parameter to dynamically change the sales target and see which products meet or exceed this target?

Sample Data
ProductCategorySales
ChairFurniture250
DeskFurniture450
PenOffice Supplies150
NotebookOffice Supplies300
PhoneTechnology600
MonitorTechnology400
Dashboard Components
  • KPI Card: Average Sales
    Formula: AVG([Sales])
    Result: 358.33
  • Parameter: Sales Target
    Type: Integer
    Current Value: 400
    Allows user to set a sales target dynamically
  • Calculated Field: Meets Target
    Formula:
    IF [Sales] >= [Sales Target] THEN 'Yes' ELSE 'No' END
    This field marks products that meet or exceed the target
  • Bar Chart: Sales by Product
    X-axis: Product
    Y-axis: Sales
    Color: Meets Target (Yes=green, No=red)
    Shows which products meet the dynamic sales target
  • Table: Product Sales and Target Status
    Columns: Product, Sales, Meets Target
    Shows detailed data with dynamic target status
Dashboard Layout
+----------------------+----------------------+
|      KPI Card        |    Sales Target      |
|   (Average Sales)    |    (Parameter)       |
+----------------------+----------------------+
|                                              |
|              Bar Chart: Sales by Product      |
|                                              |
+----------------------------------------------+
|        Table: Product Sales and Target Status |
+----------------------------------------------+
Interactivity

The Sales Target parameter lets users change the sales goal number. When the parameter changes:

  • The Calculated Field 'Meets Target' updates for each product.
  • The Bar Chart colors update to show which products meet the new target.
  • The Table updates the 'Meets Target' column accordingly.
  • The KPI Card (Average Sales) remains static as it shows overall average sales.
Self Check

If you set the Sales Target parameter to 300, which products will show 'Yes' in the 'Meets Target' column?

Answer: Desk (450), Notebook (300), Phone (600), Monitor (400) will show 'Yes'. Chair (250) and Pen (150) will show 'No'.

Key Result
Dashboard shows sales by product with a dynamic sales target parameter highlighting which products meet or exceed the target.

Practice

(1/5)
1. What is the main purpose of using a parameter in a Tableau calculated field?
easy
A. To allow users to input or select a value that changes the calculation dynamically
B. To store data permanently in the data source
C. To create a fixed filter that cannot be changed by users
D. To automatically refresh data every hour

Solution

  1. Step 1: Understand what parameters do in Tableau

    Parameters let users pick or input values that can be used in calculations or filters.

  2. Step 2: Identify the role of parameters in calculated fields

    Parameters make calculations flexible by changing their behavior based on user input.

  3. Final Answer:

    To allow users to input or select a value that changes the calculation dynamically -> Option A

  4. Quick Check:

    Parameters add interactivity = A [OK]
Hint: Parameters let users control calculations dynamically [OK]
Common Mistakes:
  • Thinking parameters store data permanently
  • Confusing parameters with fixed filters
  • Assuming parameters refresh data automatically
2. Which of the following is the correct syntax to use a parameter named Sales Target inside a calculated field in Tableau?
easy
A.
B.
C. [Sales Target]
D. {Sales Target}

Solution

  1. Step 1: Recall Tableau parameter syntax

    Parameters are referenced by their exact name inside square brackets in calculated fields.

  2. Step 2: Match the correct syntax

    The correct way is to use square brackets around the parameter name, like [Sales Target].

  3. Final Answer:

    [Sales Target] -> Option C

  4. Quick Check:

    Parameter syntax uses brackets = D [OK]
Hint: Use square brackets for parameters in calculations [OK]
Common Mistakes:
  • Using angle brackets instead of square brackets
  • Using curly braces which are for sets
  • Adding extra prefixes like
3. Given a parameter Discount Rate set to 0.1 (10%), what will be the result of this calculated field if Sales = 1000?

Sales * (1 - [Discount Rate])
medium
A. 1100
B. 900
C. 100
D. 0.9

Solution

  1. Step 1: Substitute parameter value into the formula

    Replace [Discount Rate] with 0.1: Sales * (1 - 0.1) = 1000 * 0.9

  2. Step 2: Calculate the expression

    1000 * 0.9 = 900

  3. Final Answer:

    900 -> Option B

  4. Quick Check:

    1000 * 0.9 = 900 [OK]
Hint: Multiply sales by (1 - discount) to get discounted sales [OK]
Common Mistakes:
  • Adding instead of subtracting discount
  • Using parameter value as 10 instead of 0.1
  • Confusing multiplication with division
4. You created a parameter Top N to filter the top N products by sales using this calculated field:

RANK(SUM([Sales])) <= [Top N]

But the filter does not work as expected. What is the likely issue?
medium
A. The parameter Top N is not set to an integer type
B. The calculated field syntax is incorrect; parameters cannot be used in rank functions
C. The parameter value is not connected to the filter
D. The calculation needs to be aggregated with AVG instead of SUM

Solution

  1. Step 1: Understand parameter data types

    Parameters must have the correct data type matching their use. Here, Top N should be an integer.

  2. Step 2: Identify the issue with parameter type

    If Top N is not integer, the comparison with rank (which returns integer) fails, causing filter issues.

  3. Final Answer:

    The parameter Top N is not set to an integer type -> Option A

  4. Quick Check:

    Parameter type must match usage = C [OK]
Hint: Ensure parameter type matches calculation use (integer for ranks) [OK]
Common Mistakes:
  • Assuming parameters can't be used in rank functions
  • Not linking parameter to filter action
  • Changing aggregation unnecessarily
5. You want to create a dashboard where users can select a sales threshold using a parameter Min Sales. You want to show only products with sales greater than this threshold. Which calculated field formula correctly uses the parameter to filter products?
hard
A. SUM([Sales]) < [Min Sales]
B. SUM([Sales]) >= Min Sales
C. IF [Min Sales] > SUM([Sales]) THEN 'Show' ELSE 'Hide' END
D. IF SUM([Sales]) > [Min Sales] THEN 'Show' ELSE 'Hide' END

Solution

  1. Step 1: Understand the filtering logic needed

    We want to mark products as 'Show' if their sales exceed the parameter value.

  2. Step 2: Check each formula's logic

    IF SUM([Sales]) > [Min Sales] THEN 'Show' ELSE 'Hide' END uses IF to return 'Show' when SUM([Sales]) > [Min Sales], which is correct for filtering.

  3. Step 3: Why others are incorrect

    SUM([Sales]) >= [Min Sales] returns TRUE/FALSE but may not be usable directly as a filter label. IF [Min Sales] > SUM([Sales]) THEN 'Show' ELSE 'Hide' END reverses logic. SUM([Sales]) < [Min Sales] shows products below threshold.

  4. Final Answer:

    IF SUM([Sales]) > [Min Sales] THEN 'Show' ELSE 'Hide' END -> Option D

  5. Quick Check:

    Use IF with parameter to label filter results = A [OK]
Hint: Use IF to compare sales with parameter for filtering [OK]
Common Mistakes:
  • Reversing comparison operators
  • Using boolean expressions without IF for labels
  • Confusing greater than and less than