Interface overview (data pane, shelves, canvas) in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample sales data by region used to demonstrate Tableau interface components.

Cell	Value
A1	Region
A2	North
A3	South
A4	East
A5	West
B1	Sales
B2	1000
B3	1500
B4	1200
B5	1300

Formula Trace

SUM([Sales])

Step 1: [Sales] values: 1000, 1500, 1200, 1300

Step 2: SUM(1000, 1500, 1200, 1300)

Cell Reference Map

     A       B
  +-------+-------+
1 |Region | Sales |
  +-------+-------+
2 |North  | 1000  |
3 |South  | 1500  |
4 |East   | 1200  |
5 |West   | 1300  |
  +-------+-------+

[Sales] column (B2:B5) is referenced for SUM calculation.

The formula references the Sales column cells B2 to B5 from the data pane.

Result

     A       B       C
  +-------+-------+-------+
1 |Region | Sales | Total |
  +-------+-------+-------+
2 |North  | 1000  |       |
3 |South  | 1500  |       |
4 |East   | 1200  |       |
5 |West   | 1300  | 5000  |
  +-------+-------+-------+

Total sales of 5000 is shown in the canvas area as the result of SUM([Sales]).

The canvas shows the total sales value 5000 calculated by summing the Sales column.

Sheet Trace Quiz - 3 Questions

What does the Data Pane in Tableau show?

A The list of fields and data columns available for analysis

B The final visualization output

C The shelf where you drag fields to filter data

D The menu for exporting reports

Key Result

SUM([Field]) adds all values in the specified data field to produce a total.

Practice

1. Which part of the Tableau interface shows all the data fields available for analysis?

easy

A. Data Pane

B. Shelves

C. Canvas

D. Toolbar

Solution

1. Step 1: Understand the role of the Data Pane

   The Data Pane contains all the data fields you can use in your analysis.

2. Step 2: Differentiate from other interface parts

   Shelves are for placing fields to build views, and Canvas shows the visual output, so they do not hold all fields.

3. Final Answer:

   Data Pane -> Option A

4. Quick Check:

   Data Pane = holds all data fields [OK]

Hint: Data Pane always lists your data fields [OK]

Common Mistakes:

• Confusing Shelves with Data Pane
• Thinking Canvas holds data fields
• Selecting Toolbar as data holder

2. Which shelf in Tableau is used to place fields that define the rows in a view?

easy

A. Rows Shelf

B. Columns Shelf

C. Filters Shelf

D. Pages Shelf

Solution

1. Step 1: Identify the purpose of Rows Shelf

   The Rows Shelf is where you drag fields to define the rows in your visualization.

2. Step 2: Differentiate from other shelves

   Columns Shelf defines columns, Filters Shelf filters data, and Pages Shelf controls animation or pagination.

3. Final Answer:

   Rows Shelf -> Option A

4. Quick Check:

   Rows Shelf = defines rows in view [OK]

Hint: Rows Shelf controls vertical layout [OK]

Common Mistakes:

• Mixing Rows Shelf with Columns Shelf
• Using Filters Shelf for rows
• Confusing Pages Shelf with Rows Shelf

3. If you drag a 'Sales' measure to the Columns Shelf and a 'Region' dimension to the Rows Shelf, what will the Canvas display?

medium

A. A table showing sales values for each region

B. A blank canvas because measures cannot be on Columns Shelf

C. A bar chart with regions on the vertical axis and sales on the horizontal axis

D. A pie chart of sales by region

Solution

1. Step 1: Understand shelf roles for visualization

   Dragging 'Sales' (measure) to Columns and 'Region' (dimension) to Rows creates a bar chart with sales values horizontally and regions vertically.

2. Step 2: Recognize visualization type on Canvas

   Tableau defaults to bar charts for this setup, not tables or pie charts.

3. Final Answer:

   A bar chart with regions on the vertical axis and sales on the horizontal axis -> Option C

4. Quick Check:

   Columns = measure, Rows = dimension -> bar chart [OK]

Hint: Measure on Columns + Dimension on Rows = bar chart [OK]

Common Mistakes:

• Thinking it creates a pie chart
• Assuming a table appears instead of a chart
• Believing measures can't go on Columns Shelf

4. You dragged a dimension to the Filters Shelf but the filter is not applying. What is the most likely reason?

medium

A. The field is not added to the Data Pane

B. You forgot to click 'Apply' on the filter dialog

C. Filters Shelf only works with measures

D. The Canvas is hidden

Solution

1. Step 1: Check filter application process

   After placing a field on Filters Shelf, you must confirm or click 'Apply' in the filter dialog for it to take effect.

2. Step 2: Eliminate other options

   The field must be in Data Pane to drag it; Filters Shelf works with dimensions and measures; Canvas visibility does not affect filter application.

3. Final Answer:

   You forgot to click 'Apply' on the filter dialog -> Option B

4. Quick Check:

   Filter dialog needs 'Apply' click to activate [OK]

Hint: Always click 'Apply' after setting filters [OK]

Common Mistakes:

• Assuming Filters Shelf only works with measures
• Not realizing filter dialog needs confirmation
• Thinking Canvas visibility affects filters

5. You want to create a view showing total sales by category and sub-category. Which sequence of actions correctly uses Tableau's interface?

hard

A. Drag 'Category' to Rows Shelf, 'Sub-Category' to Columns Shelf, and 'Sales' to Filters Shelf

B. Drag 'Sales' to Rows Shelf, 'Category' to Filters Shelf, and 'Sub-Category' to Columns Shelf

C. Drag 'Sales' to Data Pane, 'Category' to Canvas, and 'Sub-Category' to Shelves

D. Drag 'Category' and 'Sub-Category' to Rows Shelf, and 'Sales' to Columns Shelf

Solution

1. Step 1: Place dimensions to define rows

   Drag both 'Category' and 'Sub-Category' to the Rows Shelf to create a hierarchical row grouping.

2. Step 2: Place measure to define columns

   Drag 'Sales' (measure) to Columns Shelf to show total sales values horizontally.

3. Step 3: Verify correct use of shelves

   Filters Shelf is for filtering data, not for placing measures to display; Data Pane is where fields reside, not for dragging to create views; Canvas shows results but you don't drag fields directly there.

4. Final Answer:

   Drag 'Category' and 'Sub-Category' to Rows Shelf, and 'Sales' to Columns Shelf -> Option D

5. Quick Check:

   Dimensions on Rows + Measure on Columns = hierarchical view [OK]

Hint: Put dimensions on Rows, measure on Columns for grouped view [OK]

Common Mistakes:

• Putting measures on Filters Shelf instead of Columns
• Dragging fields directly to Canvas
• Misplacing dimensions on Filters Shelf