Dual-axis maps in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Purpose of Dual-Axis Maps in Tableau

What is the main purpose of using dual-axis maps in Tableau?

A To overlay two different geographic data layers on the same map for comparison.

B To create two separate maps side by side for different regions.

C To display time series data on a map using a single axis.

D To combine bar charts and line charts in one visualization.

💡 Hint

Think about how dual-axis maps help visualize multiple data sets geographically.

Dual-axis maps allow you to overlay two geographic layers, such as points and filled areas, on the same map to compare or combine different spatial data.

❓ dax_lod_result

intermediate

Result of a LOD Expression in Dual-Axis Map Context

Given a Tableau LOD expression that fixes the state level sales total, what is the expected result when used in a dual-axis map showing state sales and city sales?

Tableau

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

A The overall total sales for all states combined.

B The total sales summed for each state, repeated for every city in that state.

C The total sales summed for each city only.

D The average sales per state.

💡 Hint

LOD expressions with FIXED calculate values at the specified level regardless of view detail.

The FIXED LOD expression calculates total sales per state and repeats that value for every city within the state, useful for layering aggregated and detailed data on dual-axis maps.

❓ visualization

advanced

Identifying Correct Dual-Axis Map Setup

You want to create a dual-axis map in Tableau showing filled states and city points with different sizes based on sales. Which setup correctly achieves this?

A Place State on Detail and City on Detail, create two map layers, synchronize axes, and assign sales to size on city layer.

B Place State on Rows, City on Columns, create dual-axis, assign sales to label on both layers.

C Place City on Color, State on Size, create dual-axis, do not synchronize axes, assign sales to color on city marks.

D Place State on Color, City on Detail, create dual-axis, synchronize axes, assign sales to size on city marks, and fill states with color.

💡 Hint

Think about how to layer filled areas and points with size encoding on a dual-axis map.

Option D correctly places State on Color to fill states, City on Detail for points, synchronizes axes for alignment, and assigns sales to size on city marks for visual emphasis.

🔧 Formula Fix

advanced

Troubleshooting Misaligned Dual-Axis Maps

Your dual-axis map layers are not aligning properly in Tableau. What is the most likely cause?

A The map layers use different geographic roles like State and Country.

B The data source contains null values in the geographic fields.

C The axes are not synchronized between the two map layers.

D The color palette used is not compatible with maps.

💡 Hint

Check if the axes scales match between layers.

Dual-axis maps require synchronized axes to align layers correctly. Without synchronization, layers will not overlay properly.

🎯 Scenario

expert

Designing a Dual-Axis Map for Sales and Customer Density

You need to build a dual-axis map in Tableau that shows sales by state as filled areas and customer density as graduated circle points by city. Which approach best ensures accurate and clear visualization?

A Use State as filled map layer with sales color encoding, City as point layer with customer count size encoding, synchronize axes, and add tooltips for details.

B Use City as filled map layer with sales color encoding, State as point layer with customer count size encoding, do not synchronize axes, and add labels for states.

C Create two separate maps on dashboard side by side, one for sales by state and one for customer density by city, without dual-axis.

D Use State and City combined in one layer with sales and customer count both encoded as color gradients.

💡 Hint

Consider layering filled areas and points with appropriate encoding and axis synchronization.

Option A correctly uses filled states for sales, points sized by customer count for cities, synchronizes axes for alignment, and adds tooltips for clarity, ensuring an accurate dual-axis map.