Geographical (by State) distribution of cases
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Let's say I have 2 columns of data.
State - Number of cases.
What are the steps to create a map showing, by State, the number of cases?
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @va ,
Here is a potential solution. I hope it helps.
Workflow
Output
Input Data tool configuration
You need to get the data for the shape of the states from somewhere.
I use the shapefile from this site.
https://www.weather.gov/gis/USStates
Input Data tool supports Shapefile format. (.shp).
Join tool configuration
Join the polygon data to your table with State code.
Report Map tool configuration
You need to define the data to use on the map.
Then you need to add a Polygon layer.
Then you can define the Style and Label.
Reporting tools have many configuration and you need to be familiar with them.
I would recommend you check
- Interactive Lesson Mapping Data
- Tool Mastery article Report Map
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @va
You need to implement the Spatial Tools which are a set of tools under the Spatial category in your Designer; The link takes you to the Alteryx Academy Interactive videos
One of them is the Spatial Analytics, which strongly suggest you to watch.
Now, from the Spatial Analytics lessons, I downloaded the file "US_states_capitals.yxdb" containing the Spatial Objects required by the solution; I had to add the State_Name to your Excel file in order to join the two source tables; Also, the Number field you provided was too small (I did not played long enough) so I scaled it up by 5 times in the New_Number field.
The Broweser render the map.
Obviously, we are making the call "Houston we got a problem" because Texas barely shows something meaningfull 🤣
Hope this helps,
Arnaldo
