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.