Advance with Assist: Using Map Layers with Unconnected Data Sources

Data

Advance with Assist: Using Map Layers with Unconnected Data Sources

Advance with Assist shares quick solutions to common challenges encountered by the InterWorks Assist on-demand team.

Question: How do I use the new map layers feature without having to join, blend or use relationships to connect my data?

The answer to this question varies based on which version of Tableau you’re using. To work with map layers with 2021.3 or earlier, reference Ryan’s blog post. For those with 2021.4 or later, follow along here.

It’s easy! Let’s begin by jumping into a workbook with the Global Superstore data in Tableau Desktop. We start by looking at a map of the United States with each state showing its profitability ratio.

For our example, let’s say that you’re an analyst at the Superstore, and you want to look at advertising opportunities in airports across the U.S. in a combination of the states with the highest profitability, the size of the airport in terms of traffic and its flight cancellation rate. We’re going to use map layers to do this analysis quickly and easily by simply bringing in the flight data.

Finding Geographic Patterns with Map Layers

Using map layers is really simple. Once you have your first map built with your first data source, click on your second data source and drag the geographic field into the map layers button which appears in the top-left of the view. You can see how below:

Simple! Notice how you did not need to define any blend, relationship or join. Think of it as two separate sheets stuck on top of each other geographically.

For our scenario, we want to look at airports within the contiguous U.S. We can make a small adjustment to exclude the data we aren’t considering, leaving the geographic area we want to know more about:

Next, we’ll look at the number of flights across these airports. Take flights and drag them onto Size, which reveals how much traffic each airport yields. Then we’ll take cancellation rates and bring it onto Color. This highlights the airports with high cancellation rates, up to 14%, compared to those with low rates:

Have a look at all the insight we can now draw. We can compare the patterns that emerge geographically between the profitability of the states (from the original data sources) and the opportunity within the airports (cancellation rate and flight traffic) that emerges from the secondary data source—all within seconds and all without needing to connect the data sources together:

For a thorough walkthrough of this solution step by step, watch the video below:

Want More Advance with Assist

  1. Advance with Assist: Filtering Select Dates with DATETRUNC
  2. Advance with Assist: Enhancing Dashboards with Custom Icons
  3. Advance with Assist: Tableau Power User Leaving the Company
  4. Advance with Assist: Context Filters and LOD Calculations
  5. Advance with Assist: Custom Subscriptions with Tableau Server Custom Views
  6. Advance with Assist: Blending with Dimension Not Utilized
  7. Advance with Assist: Creating a Sankey Diagram from Survey Data
  8. Advance with Assist: Multiple Dashboard Actions with a Single Click
  9. Advance with Assist: Refreshing Tableau Online Data with Tableau Bridge
  10. Advance with Assist: Parameter Performance Optimization
  11. Advance with Assist: Using Custom Backgrounds with Polygon Shapefiles
  12. Advance with Assist: Changing Default Properties on Data
  13. Advance with Assist: Options for Calculating Percentages
  14. Advance with Assist: Removing Options from Filter List
  15. Advance with Assist: Extracting Year from De-identified Text String
  16. Advance with Assist: Marking the Latest Date on Trend Line
  17. Advance with Assist: What You Need to Know About Aliases
  18. Advance with Assist: Function Compatibility
  19. Advance with Assist: Mass Parameter Replacement
  20. Advance with Assist: Sorting with MONTH in Reverse
  21. Advance with Assist: Ungroup Column Headers That Have Concatenated
  22. Advance with Assist: Connectionless Failure Error in Tableau Server
  23. Advance with Assist: How to Exceed Tableau’s Column or Row Limit
  24. Advance with Assist: Adding Email Links to Your Dashboard
  25. Advance with Assist: Saving User-Selected Filters on Tableau Server
  26. Advance with Assist: Tableau and Named Ranges in Excel
  27. Advance with Assist: Editing Custom Fields in Tableau-Published Data Sources
  28. Advance with Assist: NOW and TODAY Functions in Tableau
  29. Advance with Assist: Sheet Swapping with Dummy Headers
  30. Advance with Assist: REST Error in Tableau and Snowflake Connection
  31. Advance with Assist: Mapping with One Data Row in Tableau 2019.2
  32. Advance with Assist: Multi-Number Formats for Single Calculations
  33. Advance with Assist: Removing Background Landmass on a Tableau Map
  34. Advance with Assist: Filtering Data Sources on Tableau Server
  35. Advance with Assist: Swapping Sheets in Tableau 2019.2
  36. Advance with Assist: Filling in Null Records Without Filtering
  37. Advance with Assist: Nested IF Calculations in Tableau
  38. Advance with Assist: Getting Show/Hide Buttons to Appear in Tableau Desktop
  39. Advance with Assist: Alteryx Output Error
  40. Advance with Assist: Missing Joins in Tableau 2020.2
  41. Advance with Assist: Tableau Server – Interactive MicroService Container Degraded
  42. Advance with Assist: A Shortcut for Duplicating Calculations
  43. Advance with Assist: Tableau Server License Renewal Refresh 
  44. Advance with Assist: Encrypt Tabcmd Credentials
  45. Advance with Assist: Pointing Tableau to a Named Range
  46. Advance with Assist: Tableau Server Migrations
  47. Advance with Assist: Adding ALL Selection to Parameters
  48. Advance with Assist: Uncaught Type Error in Tableau Server
  49. Advance with Assist: Site Roles Changing on Tableau Server
  50. Advance with Assist: Highlighting Points of Interest
  51. Advance with Assist: Finding Max Date and More
  52. Advance with Assist: Adding Field Names Above Bars on a Bar Chart
  53. Advance with Assist: Using Map Layers with Unconnected Data Sources

More About the Author

Rowan Bradnum

Analytics Consultant
Tableau 2022.1 New Feature Overview We’re so excited to finally be able to experience the new 2022.1 release from Tableau! With each new version, Tableau continues ...
Webinar Replay: Tableau 2021.4 – New Feature Review Convenience is the focus of Tableau’s 2021.4 release, with several long-sought-after features finding their way into your hands. Here, ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072