Heatmap according to two parameters

[pierrelouisbescond]

Hello Everyone,

I started using Spatial tools lately and I find them awesome!

I am struggling to build a heatmap where the radius length around each centroid depends on a parameter ("weight") and the corresponding color will be assigned on a color scale according to the "value" parameter.

I have attached a dummy example to help you help me 🙂

Thanks in advance,

Pierre-Louis

Value	Weight	Latitude	Longitude
2.35	0.184	49.756749	2.362857
2.42	0.035	48.118091	2.477274
2.26	0.035	50.084235	2.392416
2.36	0.064	48.376058	4.194254
2.37	0.042	46.384781	5.345632
2.34	0.052	50.477295	2.201537
2.26	0.042	50.531218	2.803554
2.30	0.038	50.637242	2.704226
2.49	0.038	48.590687	6.491653
2.37	0.037	49.139041	2.809508
2.36	0.072	47.847242	2.730942
2.39	0.058	47.78303	7.502737
2.29	0.035	49.776566	1.981089
2.49	0.046	48.82878	4.987055
2.28	0.053	50.57872	2.738071
2.27	0.169	49.860968	2.229281

[atcodedog05]

Hi @pierrelouisbescond 

Can i ask what is dimension of the weight miles/km etc

[atcodedog05]

Hi @pierrelouisbescond 

I have went ahead and consider the weight(radius) is in miles.

You can change the unit in the buffer tool.

In below configuration

You can use formula Tool to multiply weight and make it 10 miles and then use buffer.

Output:

Workflow :

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

[pierrelouisbescond]

Hi @atcodedog05 

You already deserve a like because you helped me solve one of my issues 😉

I can now define a radius based on the weight of each centroid and that is very cool!

The remaining issue I have is that I would expect to have different colors for each centroid, based on the "value" parameter. Example: 2.26 (minimum) would get a dark blue and 2.49 (maximum) would get a dark red.

At the present time, I cannot see a true difference. It seems that the color scale is broken with a range going from 2.45 to 48500 🤔 It there a way to define boundaries manually?

[atcodedog05]

Hi @pierrelouisbescond ,

The coloring is based on value density(Heat) per sqft and not only on value. Hence the scale is huge.

In the sample data there were heats.

I donno why in your output its not there. Usually at least little bit heats are visible.

Maybe its very small like since this is a country map. You can split them into state or on some region level so that you will get a zoom in.

The scale is static even Alteryx's example workflow as the same scale. I have attached the workflow.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind😀👍

[danilang · Accepted solution]

Hi @pierrelouisbescond 

The effect that you're looking for can be accomplished without the Heat Map tool.  Just add another Polygon layer to the Report Map and configure it to Use Smart Tile

The results look like this

Note that I had to increase the multiplier on the radius to get the buffer large enough to see

Dan 

[pierrelouisbescond]

Thanks @danilang ! This is exactly what I was looking for! 👌

Additional shoutout for @atcodedog05 for his support as well 😁

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀