Why table calculations compute across the view in Tableau - Why Use It

Introduction

Table calculations in Tableau perform their computations based on the data visible in the current view. This means they use the data already displayed in your worksheet to calculate results, which helps you analyze trends or differences within that specific view.

When you want to calculate running totals or moving averages based on the data shown in your chart.

When you need to compare each value to the total of all values currently displayed.

When you want to rank items within the visible data on your worksheet.

When you want to calculate percent differences between values shown in your view.

When you want to perform calculations that depend on the order or layout of data in the current visualization.

Steps

Step 1: Open your Tableau workbook and go to the worksheet with your data view

- Tableau workspace

You see your data displayed in rows and columns or as a chart

💡 Make sure your data is arranged the way you want to analyze it

Step 2: Click the drop-down arrow on a measure in the view

- Columns or Rows shelf

A menu appears with calculation options

💡 You can also right-click the measure in the data pane

Step 3: Select 'Add Table Calculation' from the menu

- Measure drop-down menu

The Table Calculation dialog box opens

💡 This dialog lets you choose how the calculation computes across the view

Step 4: Choose the calculation type (e.g., Running Total, Percent of Total)

- Table Calculation dialog box

The calculation type is applied to the measure

💡 Pick the calculation that fits your analysis goal

Step 5: Set the 'Compute Using' option to define how the calculation moves across the view

- Table Calculation dialog box under 'Compute Using'

Tableau calculates the result based on the selected direction (e.g., Table Across, Table Down)

💡 This controls whether the calculation goes across columns, down rows, or uses a custom path

Step 6: Click OK to apply the table calculation

- Table Calculation dialog box

The view updates showing the calculated results based on the visible data

💡 You can adjust the view or calculation settings to see different results

Before vs After

Before

The view shows sales numbers for each region and month without any calculations

After

The view shows running totals of sales for each region across months, calculated based on the visible data

Settings Reference

Calculation Type

📍 Table Calculation dialog box

Defines the type of table calculation to perform on the data in the view

Default: Running Total

Compute Using

📍 Table Calculation dialog box

Controls the direction and scope of the calculation across the data in the view

Default: Table Across

Restarting Every

📍 Table Calculation dialog box (for some calculations)

Determines if the calculation restarts at certain points in the view

Default: None

Common Mistakes

Expecting table calculations to use data not shown in the current view

Table calculations only compute based on the data currently visible in the worksheet

Adjust the view to include all necessary data before applying the table calculation

Choosing the wrong 'Compute Using' direction

This causes the calculation to aggregate data incorrectly across rows or columns

Select the correct direction (e.g., Table Across or Table Down) that matches how your data is arranged

Summary

Table calculations compute results based on the data visible in the current Tableau view.

You control how calculations move across the view using the 'Compute Using' setting.

Make sure your view includes all data needed before applying table calculations.

Practice

1. What does it mean when we say table calculations in Tableau "compute across the view"?

easy

A. They calculate values only from the original data source, ignoring the view.

B. They always compute totals without considering the layout.

C. They use the data visible in the current chart or table to perform calculations.

D. They only work on filtered data, not the entire view.

Solution

1. Step 1: Understand the meaning of "compute across the view"

   Table calculations use the data that is currently displayed in the view, not the entire data source.

2. Step 2: Relate to how Tableau uses visible data

   Since the calculation depends on the view, changing the layout or filters changes the calculation.

3. Final Answer:

   They use the data visible in the current chart or table to perform calculations. -> Option C

4. Quick Check:

   Table calculations depend on visible data [OK]

Hint: Table calculations use only data shown in the view [OK]

Common Mistakes:

• Thinking calculations use all data regardless of view
• Confusing table calculations with data source filters
• Assuming calculations ignore layout changes

2. Which of the following is the correct way to set the direction for a table calculation in Tableau?

easy

A. Right to Left

B. Compute Using > Table (Across)

C. Filter > Exclude

D. Data Source > Refresh

Solution

1. Step 1: Identify how to set calculation direction

   In Tableau, you set the direction by choosing 'Compute Using' and selecting options like 'Table (Across)'.

2. Step 2: Confirm correct syntax and option

   'Compute Using > Table (Across)' is the correct way to tell Tableau to calculate across the table horizontally.

3. Final Answer:

   Compute Using > Table (Across) -> Option B

4. Quick Check:

   Direction set by Compute Using [OK]

Hint: Use 'Compute Using' to set calculation direction [OK]

Common Mistakes:

• Confusing filter options with calculation direction
• Using data source refresh instead of compute using
• Selecting invalid directions like 'Right to Left'

3. Given a table with sales data by Region and Month, if a table calculation is set to compute using 'Table (Down)', what will it calculate?

medium

A. Sum of sales across all regions horizontally

B. Sum of sales only for the first month

C. Sum of sales ignoring the view layout

D. Sum of sales down each region column vertically

Solution

1. Step 1: Understand 'Table (Down)' direction

   'Table (Down)' means the calculation moves vertically down each column in the table.

2. Step 2: Apply to sales by Region and Month

   Since months are likely arranged down rows, the calculation sums sales down each region's column vertically.

3. Final Answer:

   Sum of sales down each region column vertically -> Option D

4. Quick Check:

   Table (Down) = vertical calculation [OK]

Hint: 'Table (Down)' means calculate vertically down columns [OK]

Common Mistakes:

• Thinking 'Table (Down)' calculates horizontally
• Ignoring the table layout and direction
• Assuming calculation ignores months

4. You set a table calculation to compute using 'Pane (Across)', but the results are not as expected. What is a likely cause?

medium

A. The calculation is computing only within each pane horizontally, but the view has no panes defined.

B. The data source is not connected properly.

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

D. The filter is excluding all data.

Solution

1. Step 1: Understand 'Pane (Across)' scope

   'Pane (Across)' computes horizontally but only within each pane, which is a section of the view.

2. Step 2: Check if panes exist in the view

   If the view has no panes (no partitioning), the calculation may behave unexpectedly because it expects pane boundaries.

3. Final Answer:

   The calculation is computing only within each pane horizontally, but the view has no panes defined. -> Option A

4. Quick Check:

   Pane scope needs panes in view [OK]

Hint: Check if panes exist when using 'Pane (Across)' [OK]

Common Mistakes:

• Assuming 'Pane (Across)' ignores pane boundaries
• Blaming data source connection for calculation issues
• Confusing filters with calculation scope

5. You want to calculate the running total of sales by Month within each Region in a view that shows Regions as rows and Months as columns. Which 'Compute Using' setting should you choose for the table calculation to work correctly?

hard

A. Pane (Across)

B. Pane (Down)

C. Table (Across)

D. Table (Down)

Solution

1. Step 1: Analyze the view layout

   Regions are rows, Months are columns, so months run horizontally across the view.

2. Step 2: Determine running total direction and scope

   Running total by Month within each Region means calculating horizontally across each pane (each Region is a pane).

3. Step 3: Choose correct 'Compute Using'

   'Pane (Across)' computes across columns within each pane (Region), which fits the requirement.

4. Final Answer:

   Pane (Across) -> Option A

5. Quick Check:

   Running total by Month across each Region = Pane (Across) [OK]

Hint: Match compute direction to months layout and pane to regions [OK]

Common Mistakes:

• Choosing 'Table (Across)' which ignores pane boundaries
• Using vertical directions when months are horizontal
• Not considering pane boundaries for regions