This content has been marked as final.
Show 1 reply
-
1. Re: Grouping States to Region in a MAP
Jay Morehart Jul 6, 2017 10:39 AM (in response to Jared Get)Your workbook is connected to a live file, so I cannot see the data, you would need to take an extract first, but I think I understand your question and will hopefully be able to answer it with superstore data:
Superstore has a text field "Region" (central, east, south, and west) the way the data is structured, every record has both state and region fields so we can set a geographic role for region, based off of state:
now we have the regions calculated based on the states that make them up and can throw profit on color for a filled map, colored by region rather than state:
hope this helps! if not please take an extract of your data and re-post the packaged workbook, and I will take a look