I'm trying to figure out if Business Analyst can find out the average distance to a customer's 5 closest stores. For example, we may have 10,000 customers and 1000 stores. I'd like to know what the average drive time (in miles) is from the customers to their closest 5 stores. I need to get to the point to where I can measure that all customers are 1 mile away their closest store, 2 miles from the 2nd closest store, 2.5 miles from 3 closest store, etc. You get the picture. Is this possible in Business Analyst? I've tried using Network Analyst's "Closest Facility" tool, but that keeps timing out on me because there are way too many calculations. I won't be able to break the files up because this is something I need to do somewhat frequently. Please help. John
... View more