I have a multi-point dataset for which I'd like to prepare a plot with an average nearest neighbor value on y and the nth order of neighbors for which this value was calculated on x (e.g., 1st, 2nd, 3rd.... 20th order neighbors -see attached graphic for example). I have not found a tool in Pro that will do this calculation for me yet.
The Near tool calculates a Nearest Neighbor distance for each point, which is great, since this is the type of output I am looking for, but it doesn't seem to be able to do this for nth-order neighbors. The Calculate Distance Band For Neighbors tool will calculate an average nearest neighbor score for a custom nth order neighbor, but it will only give me one value, a summary statistic, for the whole dataset, not the nth average nearest neighbor value for each point.
Essentially, I'd like to end up with an output that looks like the made up table below, where each field is the distance to the nth order neighbor for each of the points in my dataset.
| OBJECTID | NearDist1 | NearDist2 | NearDist3 | NearDist4 |
| 1 | 7 | 13 | 39 | 50 |
| 2 | 3 | 4 | 12 | 16 |
| 3 | 10 | 18 | 55 | 89 |
Does anyone have ideas on how I might do this? I'd be grateful for any advice.