Alteryx Designer Desktop Discussions

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

Determine total value inside a Buffer circle

bmarte
5 - Atom

Hi all,

 

I need to perform an aggregation analyses and I want to determine the total value contained within 1.5mile buffers across locations. I created buffers of 1.5 radius but am unable to figure out how to add up a value contained in each circle. Does anyone have any ideas on how that may be possible after the buffer tool creates that buffer polygon?

 

Note: My data has latitude and longitudes that have already been mapped using 'Create Points'.

 

Any ideas are welcomed!

7 REPLIES 7
Qiu
20 - Arcturus
20 - Arcturus

@bmarte 
I feel like a summarize tool should do the work.

Can you provide a sample data set, not sure about " total value".

bmarte
5 - Atom

Thanks Qui, I've attached the file.

Qiu
20 - Arcturus
20 - Arcturus

@bmarte 
The data is missing ...
Can you export the worfflow or just upload the CSV file if you could.

 

Qiu_0-1614905518334.png

 

bmarte
5 - Atom

Thanks Qui, uploaded the raw data, all is public data nothing proprietary.

Qiu
20 - Arcturus
20 - Arcturus

@bmarte 
Something like this should work.

0305-bmarte.PNG

bmarte
5 - Atom

Thank you, worked perfect!

Qiu
20 - Arcturus
20 - Arcturus

@bmarte 

Good to know it helps and thank you for the accept mark also😁

Labels