I have a dataset of water level tests. Each is taken at a well, on a date. There are 10s of thousands of tests, on thousands of wells. I want to know when the lowest water level was found on each well. I can use the Summarize function (or the Summary Statistics tool) to find the minimum (or maximum) value of water level elevation on each of the wells, but that does not give me the date that test was performed.
I can use a join function on the min elevation value to find dates, but that seems clunky and I am concerned that the non-integer nature of the data for that join could cause incorrect returns.
