1 Reply Latest reply on Dec 26, 2016 10:05 AM by Yuriy Fal

    Showing Data That Spans More Than One State on a Map

    Vinicius Cid

      I have some survey data that I'd like to show on a filled map. Its original form is as follow:

       

        

      ProvinceSupport
      British Columbia35%
      Alberta27%
      Saskatchewan/Manitoba23%
      Ontario33%
      Quebec32%
      Atlantic31%

       

      But I'm not sure how to get a visualization where I can group multiple states/provinces to show a single data point. My current workaround is to simply list each province separately, which yields a misleading visualization (as in, 23% in Saskatchewan + Manitoba combined is not the same as 23% in Saskatchewan, then 23% in Manitoba).

       

        

      ProvinceSupport
      British Columbia35%
      Alberta27%
      Saskatchewan23%
      Manitoba23%
      Ontario33%
      Quebec32%
      Nova Scotia31%
      New Brunswick31%
      Prince Edward Island31%
      Newfoundland & Labrador31%

       

      So yeah, all I want to do is show the original data set correctly on the map by aggregating some of the provinces into regions to reflect the way the survey handled the data. Thanks in advance!