KNOWLEDGE BASE

Showing Hawaii and Alaska Near Continental US


Published: 23 Apr 2013
Last Modified Date: 31 Aug 2020

Question

How to display Hawaii and Alaska near the continental United States.

Environment

  • Tableau Desktop 

Answer

CLICK TO EXPAND SOLUTION
Create Separate Maps

The following instructions use the sample data set Superstore and are demonstrated in the workbook downloadable from the right hand pane of this article.
 

Step 1: Create separate maps for the continental United States, Alaska, and Hawaii

  1. Double-click State to create the view.
  2. Drag Sales to Color on the Marks card.
  3. Right-click the worksheet tab and then select Duplicate Sheet.
  4. Repeat Step 3 so that there are three identical map views.
  5. Name the first worksheet "Continental US." 
  6. In the Continental US worksheet, drag State to the Filters card.
  7. Clear Alaska and Hawaii and then click OK.
  8. Click on the next worksheet tab and name it "Alaska."
  9. In the Alaska worksheet, drag State to the Filters card.
  10. Click the None, select Alaska and then click OK.
  11. Click on the last worksheet tab and name it "Hawaii."
  12. Drag State to the Filters card.
  13. Click None, select Hawaii and then click OK.

Step 2: Create a dashboard with a floating layout

  1. Drag the Continental US worksheet onto the dashboard.
  2. Under Add new sheets and objects, click Floating.
  3. Drag the Alaska and Hawaii worksheets to the dashboard.
  4. Re-arrange, re-size, and adjust color on the maps of Alaska and Hawaii as desired.
To view the steps showed in the below video, please expand the above section.
Note: the video has no sound.
 
CLICK TO EXPAND SOLUTION
(Optional) Color Formatting
(Video below) Set the color from the sheet that you will duplicate.
  1. Go to the US Continental Sheet and click Color > Edit Colors...
  2. Click the Advanced>> button
  3. Manually set the range of your measure.
  4. For example, we notice that Sales go from approximately 10926 to 1372210.
  5. When building the rest of your sheets, the color range will be applied automatically.
Alternatively, if your dashboard is already built, simply follow the steps below:
  1. Go to the US Continental Sheet and take note of the range of the measure.
  2. Go to the Alaska and Hawaii Sheets and click Color > Edit Colors...
  3. Click the Advanced>> button
  4. Manually set the range of your measure.
  5. Repeat steps 2 to 4 for the Hawaii sheet.
To view the steps showed in the below video, please expand the above section.
Note: the video has no sound.

(Optional) Multiple-select State Filter
Starting in Tableau Desktop 2020.2, set controls allow users to directly control what values are included in a set. These instructions demonstrate how to add a multiple select state filter that will hide or show the floating Alaska and Hawaii maps when appropriate.
  1. Right-click [State] in the right-hand data pane and select Create > Set…
  2. Click OK in the Create Set dialog
  3. Create a calculated field with a name like "Continental States Filter" with a calculation similar to the following:

    ( [State] != "Alaska" AND [State] != "Hawaii" )
    OR
    { FIXED : COUNTD( IF [State Set] THEN [State] END) } = 1

    The above calculation will return TRUE for all continental states (AKA not Alaska or Hawaii) OR it will return TRUE for all states (including Alaska and Hawaii) as long as only 1 states is selected in the [State Set]. This means that if the end user selects only Alaska/Hawaii, then Alaska/Hawaii will show up on the main map rather than on the embedded little map.

    This filter will set up the most that the continental map can show, and the map will be further filtered by the specific selections in the [State Set].
     
  4. Create a calculated field with a name like "Hawaii Filter" with a calculation similar to the following:

    [State] = "Hawaii"
    AND
    { FIXED : COUNTD( IF [State Set] THEN [State] END) } > 1

    The above calculation will return TRUE only for the state Hawaii when there is more than one state selected in the [State Set]. This means the embedded Hawaii map will disappear if either Hawaii is the only state selected or Hawaii has not been selected at all.
     
  5. 5. Create a calculated field with a name like "Alaska Filter" with a calculation similar to the following:

    [State] = "Alaska"
    AND
    { FIXED : COUNTD( IF [State Set] THEN [State] END) } > 1
     
  6. On the "Continental US" worksheet, do the following:
    1. Remove [State] from the Filters shelf
    2. Drag [Continental States Filter] to the Filters shelf
    3. In the Filter dialog, check True and click OK
    4. Drag [State Set] onto the Filters shelf
    5. Right-click [State Set] and select Show Set
    6. Right-click [State Set] and select Add to Context
    7. Right-click [State Set] and select Apply to Worksheets > Selected Worksheets
    8. In the Apply Filter to Worksheets dialog, check "Alaska" and "Hawaii" and click OK
  7. On the "Alaska" worksheet, do the following
    1. Remove [State] from the Filters shelf
    2. Drag [Alaska Filter] to the Filters shelf
    3. In the Filter dialog, check True and click OK. Note, True will not be an option unless Alaska is selected in [State Set]
  8. Repeat step 7 for the "Hawaii" worksheet using the [Hawaii Filter]
  9. On the combined map dashboard, do the following to show the [State Set] control:
    1. Select any of the map worksheets on the dashboard
    2. Select Analysis > Filters > State Set
Did this article resolve the issue?