Forum Discussion

sajarac's avatar
sajarac
Icon for Helper III rankHelper III
8 years ago

Filled Map custom Regions

Hi There, I have been trying to create a filled map with no luck and I hope someone can point me in the right direction.   In my data I have a column with the Sales Representatives and the regions ...
Need Help
sajarac's avatar
sajarac
Icon for Helper III rankHelper III
8 years ago

Help, help, help!!!!!!

 

Please, I am getting mental with this, it seems like none of the options works with my data.

 

Please any other sugestion?

 

Thank you kindly

 

 

sajarac's avatar
sajarac
Icon for Helper III rankHelper III
8 years ago

Hello, any guru that can help me?

 

Still trying to figure out this with no solution so far. my list is sorted like this:

 

Sales Rep          |       Region

 

SalesRepSalesRep

SalesRepID SRName Region Email Active

1Select Northwest Yes
2Sales Rep AWest Central  Yes
3Sales Rep BEast Central  Yes
4Sales Rep CNorth East Yes
5Sales Rep DGreat Lales  Yes
6Sales Rep EMid Atlantic  Yes
7Sales Rep FMountain  Yes
8Sales Rep GWestern Canada Yes
9Sales Rep H Gulf Coast Yes
10Sales Rep I Southern Yes

 

 

 

And for instance Great Lakes are OH, MI, WI and IL.

 

How can I plot in the map this? 

 

thanks in advance for any response.

 

Regards

  • cgk's avatar
    cgk
    New Member
    8 years ago

    I am not a guru, but this worked for me.  I have a data dable that lists the states, the region the states are in (such as 1 thru 5), and the regional manager for each state.  By selecting the region or regional manager as the primary filter, the map fills in based on the numberical value for each region.  Hopefully this makes some sense to you.

     

    • sajarac's avatar
      sajarac
      Icon for Helper III rankHelper III
      8 years ago

      Hi there, and thank you very much for your reply.

       

      Your solution work, but my problem is for instance in the map I have to split California in two and others states also. that is why I have to use a custom map.

       

      I found the solution in the follwoing post using the synoptic panel and the synoptic designer.

       

      thanks again.

       

      Regards

       

      Synoptic panel:

      https://okviz.com/blog/introducing-synoptic-panel-v1-4/

       

      Synoptic Designer:

      https://synoptic.design/

       

      • jmhoskinson's avatar
        jmhoskinson
        Icon for Helper I rankHelper I
        6 years ago

        I know I'm a little late to this thread, but I was able to use Filled Maps to subdivide a state. I created a column that had county level data (how I needed to divide my states) for only the states I needed to split up and just state level for other states. I then gave that column a data category of place. PBI mapped everything perfectly. Hope that helps with your problem next time it comes along!