Geographical (by State) distribution of cases

[va]

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?

[Yoshiro_Fujimori]

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.

[ArnaldoSandoval]

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