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.