Custom geocoding in Tableau - Dashboard Guide

Dashboard Mode - Custom geocoding

Business Question

Where are our top 5 stores located on the map using custom city coordinates?

Sample Data

Store	City	Sales	Latitude	Longitude
Store A	Springfield	150000	39.7817	-89.6501
Store B	Rivertown	120000	40.7128	-74.0060
Store C	Lakeside	90000	34.0522	-118.2437
Store D	Hillview	110000	41.8781	-87.6298
Store E	Mapleton	130000	29.7604	-95.3698
Store F	Brookfield	80000	33.4484	-112.0740
Store G	Greenville	70000	39.9526	-75.1652

Dashboard Components

• KPI Card: Total Sales with formula SUM([Sales]) showing 750000
• Bar Chart: Sales by Store sorted descending by sales
• Map: Store Locations using custom geocoding fields [Latitude] and [Longitude] to plot each store as a point
• Top 5 Stores Filter: Parameter or filter to show only top 5 stores by sales on all visuals
• Tooltip on Map: Shows Store, City, and Sales when hovering over points

Dashboard Layout

+----------------------+-------------------------+
|      Total Sales      |      Sales by Store     |
|       (KPI Card)      |       (Bar Chart)       |
+----------------------+-------------------------+
|                      Map (Store Locations)                    |
|                      (Custom Geocoding)                      |
+--------------------------------------------------------------+
    

Interactivity

The Top 5 Stores Filter controls which stores appear in the bar chart and on the map. When you select top 5 stores by sales, the KPI card updates to show total sales for those stores only. Hovering over map points shows detailed store info. All components update together to keep the view consistent.

Self Check

If you apply a filter to show only stores with sales above 100,000, which stores remain visible on the map and bar chart? What is the updated total sales in the KPI card?

Key Result

Dashboard showing top 5 stores' sales and locations using custom latitude and longitude coordinates.