Dual-axis maps in Tableau - Dashboard Guide

Dashboard Mode - Dual-axis maps

Dashboard Goal

Compare sales volume and customer density across different cities on the same map to see where sales are high and customer concentration is dense.

Sample Data

City	Latitude	Longitude	Sales	Customers
New York	40.7128	-74.0060	300	1500
Los Angeles	34.0522	-118.2437	250	1200
Chicago	41.8781	-87.6298	200	900
Houston	29.7604	-95.3698	180	700
Phoenix	33.4484	-112.0740	150	600

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 1080
• KPI Card: Total Customers
  Formula: SUM([Customers])
  Result: 4900
• Dual-Axis Map
  First axis: Circle marks sized by [Sales] at city coordinates
  Second axis: Density heatmap representing [Customers] concentration
  Both layers share the same geographic coordinates (Latitude, Longitude) for cities
• Table: City Sales and Customers
  Columns: City, Sales, Customers

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |    Total Customers   |
|        (KPI)          |        (KPI)         |
+----------------------+----------------------+
|                                              |
|               Dual-Axis Map                   |
|                                              |
+----------------------------------------------+
|          City Sales and Customers Table       |
+----------------------------------------------+

Interactivity

A filter for City allows users to select one or multiple cities. When applied:

• KPI cards update to show totals only for selected cities.
• The dual-axis map updates to display circles and heatmap density only for selected cities.
• The table filters to show only the selected cities' data.

Self Check

If you add a filter to select only New York and Chicago, which components update and how?

• KPI Cards: Total Sales updates to 500 (300 + 200), Total Customers updates to 2400 (1500 + 900).
• Dual-Axis Map: Shows circles sized for New York and Chicago sales and heatmap density for their customers only.
• Table: Displays only New York and Chicago rows.

Key Result

A dashboard showing total sales and customers with a dual-axis map combining sales circles and customer density heatmap by city.