Custom table calculation scope in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Table Calculation Scope in Tableau

In Tableau, when you create a table calculation, the scope determines which data the calculation processes. Which of the following best describes the effect of setting the scope to Pane (Down)?

A The calculation is computed separately for each vertical pane, moving down the rows within that pane.

B The calculation is computed across the entire table horizontally, ignoring panes.

C The calculation is computed for the entire table, ignoring any pane divisions.

D The calculation is computed separately for each horizontal pane, moving across the columns within that pane.

💡 Hint

Think about how data is grouped visually in panes and how the calculation moves down rows.

Setting the scope to Pane (Down) means Tableau calculates the result separately for each vertical pane, moving down the rows within that pane. This limits the calculation to the data inside each pane vertically.

❓ dax_lod_result

intermediate

Result of Table Calculation with Specific Scope

Consider a Tableau table with sales data by Region (rows) and Month (columns). You apply a running total table calculation on Sales with scope set to Table (Across). What will be the running total value for the last month in the first region?

Tableau

Region: East, Months: Jan=100, Feb=150, Mar=200
Running Total with scope Table (Across)

A 650 (sum of all months and all regions)

B 450 (sum of Jan, Feb, Mar for all regions combined)

C 200 (value of Mar only for East region)

D 450 (sum of Jan, Feb, Mar for East region only)

💡 Hint

Scope Table (Across) means calculation moves across columns for each row.

With scope Table (Across), the running total sums values across the months (columns) for each region (row) independently. For East region, the total for Jan, Feb, Mar is 100 + 150 + 200 = 450.

❓ visualization

advanced

Choosing the Correct Scope for Percent of Total

You want to create a visualization showing each product's sales as a percentage of total sales within each category. Which table calculation scope should you use to get the correct percentage?

A Pane (Down) to calculate percent within each category pane vertically.

B Table (Down) to calculate percent across all products vertically ignoring categories.

C Table (Across) to calculate percent across all products horizontally ignoring categories.

D Pane (Across) to calculate percent within each category pane horizontally.

💡 Hint

Think about how categories are grouped in panes and how you want to calculate percentages within those groups vertically.

Using Pane (Down) scope calculates the percent of total within each category pane vertically down the products, which matches the requirement to show percent within each category.

🔧 Formula Fix

advanced

Debugging Unexpected Table Calculation Results

You created a running total table calculation on Sales with scope set to Pane (Across), but the totals reset unexpectedly within the pane. What is the most likely cause?

A The running total is applied on a measure that contains null values, causing resets.

B The data is partitioned into multiple panes due to additional dimensions in the view, causing resets.

C The calculation is ignoring pane boundaries and summing across the entire table.

D The scope setting is invalid and Tableau defaults to Table (Down).

💡 Hint

Consider how adding dimensions affects pane divisions and calculation partitions.

Additional dimensions in the view can create multiple panes. With scope Pane (Across), the running total resets at each pane boundary, causing unexpected resets.

🎯 Scenario

expert

Designing a Custom Table Calculation Scope for Complex Layout

You have a Tableau dashboard showing sales by Region (rows), Product Category (columns), and Year (filter). You want a running total that restarts for each Region and Product Category combination but sums across months within the year. Which scope and addressing should you choose?

A Set scope to Table (Across) with addressing on Region and Product Category, ignoring Month.

B Set scope to Pane (Across) with addressing on Month, restarting at each Region pane only.

C Set scope to Pane (Down) with addressing on Month, restarting at each Region and Product Category pane.

D Set scope to Table (Down) with addressing on Product Category and Month, ignoring Region.

💡 Hint

Think about how panes are defined by Region and Product Category and how the calculation should move down months.

Setting scope to Pane (Down) with addressing on Month means the running total sums months vertically within each pane defined by Region and Product Category, restarting at each pane boundary as required.

Practice

1. What does the Custom Table Calculation Scope control in Tableau?

easy

A. Which data points are included in the calculation

B. The color scheme of the visualization

C. The font size of labels

D. The data source connection type

Solution

1. Step 1: Understand the purpose of table calculation scope

   The scope defines which data points Tableau uses when performing calculations like running totals or rankings.

2. Step 2: Identify what is controlled by scope

   It controls the subset of data included in the calculation, not visual formatting or data source settings.

3. Final Answer:

   Which data points are included in the calculation -> Option A

4. Quick Check:

   Scope controls data points included [OK]

Hint: Scope means which data points calculation uses [OK]

Common Mistakes:

• Confusing scope with visual formatting
• Thinking scope changes data source
• Mixing scope with filter settings

2. Which option correctly sets the scope of a table calculation to compute using only the Region dimension in Tableau?

easy

A. Compute Using > Pane (Across)

B. Compute Using > Table (Down)

C. Compute Using > Region

D. Compute Using > Table (Across)

Solution

1. Step 1: Identify the dimension to set scope

   To limit calculation to the Region dimension, select Compute Using > Region.

2. Step 2: Understand Compute Using options

   Options like Table (Down) or Table (Across) use the entire table direction, not a specific dimension.

3. Final Answer:

   Compute Using > Region -> Option C

4. Quick Check:

   Compute Using dimension name sets scope [OK]

Hint: Choose dimension name under Compute Using for scope [OK]

Common Mistakes:

• Selecting Table (Down) instead of dimension
• Confusing Pane with Table scope
• Not selecting specific dimension

3. Given a sales table with dimensions Region and Category, what will be the result of a running total table calculation with scope set to Compute Using: Category for Region 'West'?

medium

A. Running total sums all data ignoring Region and Category

B. Running total resets for each Category within the West region

C. Running total resets for each Region ignoring Category

D. Running total sums all Categories across all Regions

Solution

1. Step 1: Understand scope set to Category

   Compute Using Category means the running total computes along the Category dimension, restarting (partitioned) by other dimensions like Region.

2. Step 2: Consider Region filter 'West'

   Filtered to West, the running total resets for each Category within the West region.

3. Final Answer:

   Running total resets for each Category within the West region -> Option B

4. Quick Check:

   Compute Using Category: along Category, reset by Region [OK]

Hint: Compute Using sets addressing (along), partition sets reset [OK]

Common Mistakes:

• Thinking running total sums all regions
• Ignoring filter on Region
• Confusing scope with partitioning

4. You set a table calculation to Compute Using: Table (Across) but the running total is incorrect. What is the most likely cause?

medium

A. The table calculation is not enabled

B. The calculation is missing a filter

C. The data source is not connected

D. The data is arranged vertically, but scope is set horizontally

Solution

1. Step 1: Analyze Compute Using Table (Across)

   This scope computes calculation across columns (horizontally).

2. Step 2: Check data arrangement

   If data is arranged vertically (down rows), computing across columns causes incorrect results.

3. Final Answer:

   The data is arranged vertically, but scope is set horizontally -> Option D

4. Quick Check:

   Scope direction must match data layout [OK]

Hint: Match Compute Using direction to data layout [OK]

Common Mistakes:

• Ignoring data layout when setting scope
• Assuming filters cause running total errors
• Thinking data source connection affects calculation

5. You want to create a running total of sales that restarts for each Region and sums across Category. Which custom table calculation scope should you use?

hard

A. Compute Using: Category, Restarting every Region

B. Compute Using: Region, Restarting every Category

C. Compute Using: Table (Down)

D. Compute Using: Pane (Across)

Solution

1. Step 1: Understand requirement

   Running total should sum across Category but restart for each Region.

2. Step 2: Set scope to Category and partition by Region

   Setting Compute Using to Category calculates running total across categories. Restarting every Region means partitioning by Region.

3. Step 3: Confirm other options

   Other options do not correctly partition or compute as required.

4. Final Answer:

   Compute Using: Category, Restarting every Region -> Option A

5. Quick Check:

   Scope by Category with restart per Region [OK]

Hint: Compute Using dimension to sum, partition to restart [OK]

Common Mistakes:

• Confusing which dimension to compute using
• Not setting restart partition correctly
• Using Table (Down) which sums entire table