US GeoMap Shows US states When Other Countries Are Selected

Answered

Follow

Joe McClure

May 12, 2017 19:14

The directions tell youIf you add a field containing US states, make sure to select USA from MAP TYPE in the design panel on the right.   https://documentation.sisense.com/area-map/ However, selecting that map type does not constrain the map from showing Washington when Australia is selected.  The two letter codes for states are not exclusive to the US.  

Not all data sets Sisense has to work with may have a Country field.  So, what I'm looking for is a way to tweak the Javascript so I can specify an additional WHERE to the Widget.  If I put a filter on it, that will interfere with the Dashboard filters.

0

• 

  Yoni Lerner June 07, 2017 16:17

  Hi Joe,

   

  What I did in the past is to generate longitude latitude for my cities

   

  I created a table with all my countries and cities, then export it to csv and us that to generate the coordinates using this site.

  Finally I added/created a location dimension 

  1

  Comment actions Permalink
• 

  Joe McClure June 07, 2017 16:32

  Thanks, Yoni!

  I have a country field in my cube, isn't that enough of a location dimension?  I don't know how to tweak the widget to limit my results to where the country = 'United States'.  It seems like less of a data heavy solution.

  0

  Comment actions Permalink
• 

  Yoni Lerner June 14, 2017 14:40

  Hi Joe,

  the solution above can work for scatte map and not area map.

  Area map can work only with US states or country name, if you wish to show state level select the US map on the left on the design panel 

  0

  Comment actions Permalink

Please sign in to leave a comment.