I have a set of data that contains the lat,lng/ address of all my customers as well as the amount of product they have purchased within the last year. I would like to run that data through an Alteryx workflow and calculate what the optimal locations are for a specific number of warehouses. For example, I would like to be able to enter 12 and get 12 optimized warehouse locations. The other factor I would like to take into account is the purchase amount for each customer. So rather than using straight-line distace, I would like to use a weighted distance which is the distance from a customer to the potential warehouse multiplied by that customers purchased goods. Is there any way to do something like this within Alteryx? I have been trying for many hours but can not seem to get anything to work.
