Heatmap - Not all data points are showing

[MacyMolly]

Hi Everyone,

Need your help on this. I'm trying to create heatmap visualization however, not all data points are showing on the map. I have attached a link if you want to check the sample data. 

data 

[HotChilli]

What do you have in each field well?

I know that a heatmap is required but showing what?  The sum of PER_HM on a zipcode basis or using the latitude and longitude to plot each point?

[MacyMolly]

@HotChilli ,
I want to show the sum of the PER_HMI on a zipcode basis, however, not all of them are showing.

[HotChilli]

What visual are you using?

What do you have in each field well?

What is your desired result?

[MacyMolly]

Hi @HotChilli ,
I'm using maps visualizaiton. There's a link on my first message for you to check the data. I'm trying to create a heatmap, however, not all of the data points are showing on the maps. I'm new to this so i'm not sure if there's a way to show all the datapoints using PER_HMI(refer to the above link for the data) as size of the bubbles.