Review Location Matches for a Map Visualization

You can review mismatch issues between data and match results in map layers, such as when there are ambiguous or partial matches between words.

If ambiguous results are present, consider adding more columns to the map visualization to get the specific match. For example, your map might have layers for City, Country, and Continent. You can also exclude rows of data.

  1. On the Home page, select a workbook containing a map visualization, click the Actions menu, and then select Open.
  2. Click the Visualization tab.
  3. Right-click the map visualization and select Location Matches from the menu to display the Location Matches dialog.
  4. Select a tab representing a map layer in the current visualization to inspect how well your data matches the map layer.

    For example, select the Country tab to see how well your data matches with the Country map layer.

  5. Optional: Click Map Layer to select a different layer or click Manage Map Layers to display the Console page.
  6. Review and resolve data mismatches use the columns.
    Use Match to see what data items match with the map layer information. A match can be anything from No Match, Partial Match, to a 100% match. Matches are displayed initially sorted top down from the worst to the best matches.
    • No Match - Displays a red warning triangle indicator.
    • A Match with an issue - Displays a yellow warning triangle indicator.

      The warning doesn't indicate a poor match but an imperfect match for which you might want to review the use case.

    • A Perfect Match - Displays no warning triangle indicator.
    • If you are matching Latitude and Longitude, the match values are Valid or Invalid.

    The summary section above the table displays the number of locations and any issues.

  7. Click the filter icon in the Match column title and select a filter option.
    • Use All Data to display all types of matches.
    • Use Good Matches to display only 100% perfect matches.
    • Use All Issues to display partial matches, multiple matches and no match.
    • Use Partial Matches to indicate the percentage difference between the strings being matched. For example: Part of a string is exactly right, such as Paulo versus Sao Paulo. Most of a word is exactly right, such as Caiyro versus Cairo.
    • Use Multiple Matches to indicate how many matches exist for ambiguous cases. For example, you may see Barcelona, Spain matching with Barcelona Argentina. In this case you might want to revisit the data to add more detail to your GEO columns to ensure that you only match the correct columns.
  8. Click in the Exclude column for each row of data that you want to exclude.
  9. Click the Exclude menu:
    • Click Select All or Deselect All.
    • Click one of Workbook Scope, Canvas Scope, or Visual Scope.
  10. Optional: Add in more columns to the Category (Location) edge on the visualization to make your match more specific. For example, add Country data to remove a mismatch like Barcelona, Spain versus Barcelona, Argentina.
  11. Display the Location Matches dialog to check the summary for any remaining mismatches, and click OK when you are satisfied, or repeat previous steps as required.