Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAReally cool way to learn spatial analytics!
Creating the points and finding the closest warehouse in each example was the easy part. Then joining this to the original items data and summarizing the totals took me longer.
Please find attached my solution. I must admit that I looked at the solution in the end. I'd got all the tools and the workflow completely right but the totals were off. It was only realising that I needed to use the [Assigned] field (wasn't really sure what this was representing). So happy I was pretty much there just missing a small calculation.