Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANew to spatial tools - definitely should have read all the descriptions and looked at the 'Find Nearest' tool before I backed into it haha.
Honestly, this one was a little hard to understand... and I'm probably the last person to give writing advice... But it was clear to me to treat each unit of each item separately to calculate the cumulative distance of all units by Item. I had to peek at the solution to glean that and it was simple at that point. first time seeing the Find Nearest Spatial tool. That saved a couple of steps compared to my initial approach of appending the warehouse info to each store to find the nearest warehouse's distance.