Symbol maps in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct symbol map visualization

You have a dataset with sales data by city and want to create a symbol map in Tableau that shows sales volume using circle sizes. Which option correctly describes the best practice for this visualization?

A Drag city to Columns, sales to Rows, and use Line mark type.

B Place sales on Color, city on Rows, and use Bar chart mark type.

C Use the city field on Detail, sales on Size, and set the mark type to Circle.

D Use sales on Label, city on Tooltip, and set mark type to Shape.

💡 Hint

Think about how symbol maps use size to represent values on a geographic location.

Symbol maps use geographic fields on Detail and size to represent a measure. Setting the mark type to Circle allows size to vary by sales volume.

❓ dax_lod_result

intermediate

Calculate total sales per city ignoring filters

In Tableau, you want to create a calculated field that shows total sales per city regardless of any filters applied on other fields. Which Tableau LOD expression achieves this?

Tableau

{ FIXED [City] : SUM([Sales]) }

A { FIXED [City] : SUM([Sales]) }

B { EXCLUDE [City] : SUM([Sales]) }

C { INCLUDE [City] : SUM([Sales]) }

D SUM([Sales])

💡 Hint

Consider which LOD expression fixes the calculation at the city level ignoring other filters.

The FIXED LOD expression calculates the sum of sales for each city regardless of other filters or dimensions in the view.

❓ data_modeling

advanced

Optimize symbol map performance with large datasets

You have a symbol map in Tableau showing thousands of points for customer locations. The map is slow to load. What is the best approach to improve performance without losing important detail?

A Increase the size of symbols to cover more points and reduce the number of marks.

B Aggregate customer locations to postal code level and use aggregated data for the symbol map.

C Remove the geographic field and use a text table instead.

D Add more filters to show only a few customers at a time.

💡 Hint

Think about reducing the number of marks by grouping data.

Aggregating locations to a higher geographic level reduces the number of marks, improving performance while preserving meaningful spatial information.

🎯 Scenario

advanced

Designing a symbol map with multiple measures

You want to create a symbol map in Tableau that shows sales volume by city using circle size and profit margin by city using color. Which combination of fields and mark settings will achieve this?

A Place city on Detail, sales on Size, profit margin on Color, and set mark type to Circle.

B Place city on Rows, sales on Columns, profit margin on Label, and use Bar mark type.

C Place city on Color, sales on Size, profit margin on Tooltip, and use Shape mark type.

D Place city on Detail, profit margin on Size, sales on Color, and set mark type to Line.

💡 Hint

Remember symbol maps use geographic fields on Detail and size/color to represent measures.

Using city on Detail ensures geographic placement. Sales on Size controls circle size, and profit margin on Color shows margin differences by color.

🔧 Formula Fix

expert

Identify the error in this Tableau symbol map calculation

Given this calculated field for symbol size:
IF SUM([Sales]) > 10000 THEN SIZE() ELSE 5 END
What error will Tableau show when using this in a symbol map?

A The calculation will cause a syntax error due to missing ELSE keyword.

B The calculation will cause a type mismatch error because SIZE() returns a string.

C The calculation will run but SIZE() returns the number of marks, not a size value.

D SIZE() function cannot be used in calculated fields; it causes an error.

💡 Hint

Check if SIZE() is valid inside calculated fields for size encoding.

SIZE() is a table calculation that cannot be used directly in calculated fields for mark size. Using it causes an error.

Practice

1. What is the main purpose of a symbol map in Tableau?

easy

A. To display data points on a map using shapes or icons

B. To create bar charts with geographic data

C. To show trends over time using lines

D. To summarize data in tables

Solution

1. Step 1: Understand symbol map function

   A symbol map uses shapes or icons to represent data points on a geographic map.

2. Step 2: Compare with other chart types

   Bar charts, line charts, and tables serve different purposes than symbol maps.

3. Final Answer:

   To display data points on a map using shapes or icons -> Option A

4. Quick Check:

   Symbol maps = data points with icons on maps [OK]

Hint: Symbol maps = points on maps with icons or shapes [OK]

Common Mistakes:

• Confusing symbol maps with bar or line charts
• Thinking symbol maps summarize data in tables
• Assuming symbol maps show trends over time

2. Which of the following is the correct way to create a symbol map in Tableau?

easy

A. Drag Sales to Rows and Profit to Columns, then set mark type to Bar

B. Drag Latitude to Rows and Longitude to Columns, then set mark type to Shape

C. Drag Date to Columns and Region to Rows, then set mark type to Line

D. Drag Customer Name to Rows and Category to Columns, then set mark type to Text

Solution

1. Step 1: Identify correct fields for symbol map

   Latitude and Longitude fields are needed to place points on a map.

2. Step 2: Set mark type to Shape

   Symbol maps use shapes or icons, so mark type must be Shape.

3. Final Answer:

   Drag Latitude to Rows and Longitude to Columns, then set mark type to Shape -> Option B

4. Quick Check:

   Latitude + Longitude + Shape = Symbol map [OK]

Hint: Use Latitude and Longitude with Shape mark type [OK]

Common Mistakes:

• Using non-geographic fields for map axes
• Choosing Bar or Line mark types instead of Shape
• Not using Latitude and Longitude for placement

3. Given a symbol map with sales data, what happens if you drag the Sales field to the Size shelf?

medium

A. The color of each symbol changes to represent sales amount

B. The symbols are replaced by bars showing sales

C. The size of each symbol changes to represent sales amount

D. The map switches to a filled map

Solution

1. Step 1: Understand Size shelf effect

   Dragging a measure like Sales to Size changes symbol size proportionally.

2. Step 2: Confirm symbol map behavior

   Symbol maps use size to show quantity differences; color changes require Color shelf.

3. Final Answer:

   The size of each symbol changes to represent sales amount -> Option C

4. Quick Check:

   Sales on Size shelf = symbol size changes [OK]

Hint: Size shelf controls symbol size on maps [OK]

Common Mistakes:

• Confusing Size with Color shelf
• Expecting bars instead of symbols
• Thinking map type changes automatically

4. You created a symbol map but all symbols appear at the same spot. What is the most likely cause?

medium

A. Latitude and Longitude fields are missing or not assigned correctly

B. The Size shelf is empty

C. The Color shelf has too many colors

D. The data source is filtered by date

Solution

1. Step 1: Check geographic field assignment

   If Latitude and Longitude are missing or not assigned, Tableau places all points at default location.

2. Step 2: Rule out other causes

   Size or Color shelves do not affect symbol placement; filters affect data but not symbol overlap.

3. Final Answer:

   Latitude and Longitude fields are missing or not assigned correctly -> Option A

4. Quick Check:

   Missing Lat/Long = symbols overlap [OK]

Hint: Check Latitude and Longitude fields for correct placement [OK]

Common Mistakes:

• Blaming Size or Color shelves for placement issues
• Ignoring missing geographic data
• Assuming filters cause symbol overlap

5. You want to create a symbol map showing store locations with symbol size representing sales and symbol color representing profit margin. Which steps should you follow?

hard

A. Place Longitude on Rows, Latitude on Columns, set mark type to Line, drag Sales to Color

B. Place Sales on Rows, Profit Margin on Columns, set mark type to Bar, drag Latitude to Color

C. Place Store Name on Rows, Sales on Columns, set mark type to Text, drag Profit Margin to Size

D. Place Latitude on Rows, Longitude on Columns, set mark type to Shape, drag Sales to Size, drag Profit Margin to Color

Solution

1. Step 1: Assign geographic fields correctly

   Latitude goes on Rows and Longitude on Columns for map placement.

2. Step 2: Set mark type and assign measures

   Set mark type to Shape for symbol map; drag Sales to Size and Profit Margin to Color to encode data visually.

3. Final Answer:

   Place Latitude on Rows, Longitude on Columns, set mark type to Shape, drag Sales to Size, drag Profit Margin to Color -> Option D

4. Quick Check:

   Lat/Long + Shape + Size + Color = Symbol map with data [OK]

Hint: Use Lat/Long + Shape + Size + Color for detailed symbol maps [OK]

Common Mistakes:

• Swapping Latitude and Longitude positions
• Using wrong mark types like Bar or Line
• Assigning measures to wrong shelves