Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
21 - Polaris
21 - Polaris

@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
21 - Polaris
21 - Polaris

@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
21 - Polaris
21 - Polaris

@bmarte 
Something like this should work.

0305-bmarte.PNG

bmarte
5 - Atom

Thank you, worked perfect!

Qiu
21 - Polaris
21 - Polaris

@bmarte 

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

Labels
Top Solution Authors