Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Heatmap according to two parameters

pierrelouisbescond
8 - Asteroid

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

 

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @pierrelouisbescond 

 

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

atcodedog05
22 - Nova
22 - Nova

Hi @pierrelouisbescond 

 

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

 

You can change the unit in the buffer tool.

atcodedog05_0-1601823470454.png

In below configuration

atcodedog05_1-1601823509265.png

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

 

Output:

atcodedog05_2-1601824126922.png

Workflow :

atcodedog05_3-1601824147408.png

 

Hope this helps 🙂

 

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

pierrelouisbescond
8 - Asteroid

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?

 

screenshot.89.png

atcodedog05
22 - Nova
22 - Nova

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.

atcodedog05_0-1601836716187.png

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
19 - Altair
19 - Altair

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

 

c.png

 

The results look like this

 

m.png

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

 

Dan 

pierrelouisbescond
8 - Asteroid

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

Additional shoutout for @atcodedog05 for his support as well 😁

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂

 

Cheers and happy analyzing 😀

Labels