Shape encoding in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by product category used to assign different shapes in Tableau visualization.

Cell	Value
A1	Category
B1	Sales
A2	Fruits
B2	150
A3	Vegetables
B3	100
A4	Dairy
B4	80
A5	Meat
B5	120

Formula Trace

IF [Category] = 'Fruits' THEN 'Circle' ELSEIF [Category] = 'Vegetables' THEN 'Square' ELSEIF [Category] = 'Dairy' THEN 'Triangle' ELSE 'Diamond' END

Step 1: [Category] = 'Fruits'

Step 2: IF True THEN 'Circle' ELSE ...

Step 3: [Category] = 'Vegetables'

Step 4: IF False THEN 'Circle' ELSEIF True THEN 'Square' ELSE ...

Step 5: [Category] = 'Dairy'

Step 6: IF False THEN 'Circle' ELSEIF False THEN 'Square' ELSEIF True THEN 'Triangle' ELSE 'Diamond'

Step 7: IF False THEN 'Circle' ELSEIF False THEN 'Square' ELSEIF False THEN 'Triangle' ELSE 'Diamond'

Cell Reference Map

   A         B
1 Category  Sales
2 Fruits    150
3 Vegetables 100
4 Dairy     80
5 Meat      120

Arrows:
Category (A2:A5) --> Shape encoding formula

The formula uses the Category column (A2 to A5) to decide which shape to assign.

Result

Category   Sales   Shape
Fruits     150     Circle
Vegetables 100     Square
Dairy      80      Triangle
Meat       120     Diamond

Each category is assigned a shape based on the formula: Fruits get Circle, Vegetables Square, Dairy Triangle, and Meat Diamond.

Sheet Trace Quiz - 3 Questions

What shape is assigned to the category 'Vegetables'?

A Circle

B Square

C Triangle

D Diamond

Key Result

IF condition1 THEN shape1 ELSEIF condition2 THEN shape2 ELSEIF condition3 THEN shape3 ELSE shape4 END

Practice

1. What is the main purpose of using Shape encoding in Tableau visualizations?

easy

A. To change the color of the chart background

B. To sort data in ascending order

C. To represent different categories using distinct shapes

D. To filter data based on date

Solution

1. Step 1: Understand what shape encoding does

   Shape encoding assigns different shapes to data categories to visually separate them.

2. Step 2: Compare options to the purpose

   Only To represent different categories using distinct shapes describes using shapes for categories, others describe unrelated functions.

3. Final Answer:

   To represent different categories using distinct shapes -> Option C

4. Quick Check:

   Shape encoding = Different shapes for categories [OK]

Hint: Shapes show categories visually, not colors or sorting [OK]

Common Mistakes:

• Confusing shape encoding with color encoding
• Thinking shape encoding sorts or filters data
• Assuming shape encoding changes chart background

2. Which of the following is the correct way to apply shape encoding in Tableau?

easy

A. Drag a dimension to the Shape mark on the Marks card

B. Drag a dimension to the Color mark on the Marks card

C. Drag a measure to the Shape mark on the Marks card

D. Drag a measure to the Size mark on the Marks card

Solution

1. Step 1: Identify what type of field controls shape encoding

   Shape encoding uses categories, which are dimensions, not measures.

2. Step 2: Match the correct mark for shape encoding

   Shapes are assigned by dragging a dimension to the Shape mark on the Marks card.

3. Final Answer:

   Drag a dimension to the Shape mark on the Marks card -> Option A

4. Quick Check:

   Dimension + Shape mark = Shape encoding [OK]

Hint: Drag dimensions, not measures, to Shape mark [OK]

Common Mistakes:

• Dragging measures instead of dimensions to Shape
• Using Color mark instead of Shape mark
• Confusing Size mark with Shape mark

3. Given a dataset with a dimension 'Product Category' having values 'A', 'B', and 'C', and you drag this dimension to the Shape mark, what will Tableau do by default?

medium

A. Assign three different shapes, one for each category

B. Assign the same shape to all categories

C. Show a color legend instead of shapes

D. Create a filter to select categories

Solution

1. Step 1: Understand Tableau's default behavior with shape encoding

   When a dimension with multiple categories is placed on Shape, Tableau assigns a unique shape to each category.

2. Step 2: Evaluate the options

   Assign three different shapes, one for each category matches this behavior; others describe unrelated or incorrect outcomes.

3. Final Answer:

   Assign three different shapes, one for each category -> Option A

4. Quick Check:

   Dimension categories = unique shapes [OK]

Hint: Each category gets a unique shape by default [OK]

Common Mistakes:

• Expecting same shape for all categories
• Confusing shape legend with color legend
• Thinking shape encoding creates filters

4. You dragged a dimension to the Shape mark, but all data points show the same shape. What is the most likely reason?

medium

A. The data source is not connected

B. The dimension has only one unique value

C. The Shape mark is disabled in Tableau

D. You dragged a measure instead of a dimension

Solution

1. Step 1: Check the dimension's uniqueness

   If the dimension has only one unique value, Tableau assigns the same shape to all points.

2. Step 2: Consider other options

   Dragging a measure would not assign shapes properly, but the question states a dimension was dragged. Shape mark cannot be disabled, and data connection issues would prevent visualization.

3. Final Answer:

   The dimension has only one unique value -> Option B

4. Quick Check:

   Single unique value = same shape [OK]

Hint: Check if dimension has multiple unique values [OK]

Common Mistakes:

• Assuming Shape mark can be disabled
• Confusing dimension with measure
• Ignoring data connection status

5. You want to create a scatter plot showing sales by profit, and use shape encoding to distinguish regions. However, some regions have too many categories, making shapes hard to distinguish. What is the best approach to improve clarity?

hard

A. Increase the size of all shapes to make them bigger

B. Use shape encoding on the sales measure instead of regions

C. Remove the shape encoding and use only color encoding

D. Group similar regions into fewer categories before applying shape encoding

Solution

1. Step 1: Identify the problem with too many shape categories

   Too many shapes make it hard to distinguish categories visually.

2. Step 2: Find the best solution to reduce complexity

   Grouping similar regions reduces the number of categories, making shapes clearer.

3. Step 3: Evaluate other options

   Using shape on a measure or removing shape encoding loses category distinction; increasing size doesn't solve shape confusion.

4. Final Answer:

   Group similar regions into fewer categories before applying shape encoding -> Option D

5. Quick Check:

   Reduce categories for clear shapes [OK]

Hint: Group categories to reduce shape variety [OK]

Common Mistakes:

• Applying shape encoding to measures
• Relying on size instead of reducing categories
• Removing shape encoding without replacement