Is it possible to create a territory map in Domo? If I have a list of salespeople and the states they manage, would it be possible to list each salesperson as a different color on a map of the US?
There isn't an option to color in an entire state based on a series because the normal map behaves more like a heatmap with color chosen by the value associated with that state. What you could do, however, is use the Latitude/Longitude Map to place dots and labels on the map for each state. You'd just need to join some average lat/long values for the states onto the territory data. Here's a list of Lat/Long values for the states:
AK,61.3850,-152.2683AL,32.7990,-86.8073AR,34.9513,-92.3809AS,14.2417,-170.7197AZ,33.7712,-111.3877CA,36.1700,-119.7462CO,39.0646,-105.3272CT,41.5834,-72.7622DC,38.8964,-77.0262DE,39.3498,-75.5148FL,27.8333,-81.7170GA,32.9866,-83.6487HI,21.1098,-157.5311IA,42.0046,-93.2140ID,44.2394,-114.5103IL,40.3363,-89.0022IN,39.8647,-86.2604KS,38.5111,-96.8005KY,37.6690,-84.6514LA,31.1801,-91.8749MA,42.2373,-71.5314MD,39.0724,-76.7902ME,44.6074,-69.3977MI,43.3504,-84.5603MN,45.7326,-93.9196MO,38.4623,-92.3020MP,14.8058,145.5505MS,32.7673,-89.6812MT,46.9048,-110.3261NC,35.6411,-79.8431ND,47.5362,-99.7930NE,41.1289,-98.2883NH,43.4108,-71.5653NJ,40.3140,-74.5089NM,34.8375,-106.2371NV,38.4199,-117.1219NY,42.1497,-74.9384OH,40.3736,-82.7755OK,35.5376,-96.9247OR,44.5672,-122.1269PA,40.5773,-77.2640PR,18.2766,-66.3350RI,41.6772,-71.5101SC,33.8191,-80.9066SD,44.2853,-99.4632TN,35.7449,-86.7489TX,31.1060,-97.6475UT,40.1135,-111.8535VA,37.7680,-78.2057VI,18.0001,-64.8199VT,44.0407,-72.7093WA,47.3917,-121.5708WI,44.2563,-89.6385WV,38.4680,-80.9696WY,42.7475,-107.2085
If you make a dataset out of this and then join it to your data using a quick Magic ETL dataflow, you should then have what you'd need to build the map.
I'd recommend using the state name for the LABEL NAME, perhaps a book of business total for the state as the VALUE, and the rep name as the SERIES for COLOR. Using this set up, you'll get a dot in each state, colored according to which rep has that state and sized according to the book of business total for that state.
Does that help? Let me know if I need to clarify anything.
@amwright, did zcameron's reply help you out?
Yes - not ideal but is a reasonable workaround for now.
Thank you!
Thank you - this works!
Thanks for this walk through. Any tips on affordable apis for generating long and lat values for specific locations?
Google has a good API for doing this. It's the same one used by Google Maps.
https://developers.google.com/maps/documentation/geocoding/start
