Hi @zoe, building on previous suggestions from "gcusello & tscroggins" , especially that sometimes y1 and y2 might not be exactly equal but rather close to each other, I would use the following meth...
See more...
Hi @zoe, building on previous suggestions from "gcusello & tscroggins" , especially that sometimes y1 and y2 might not be exactly equal but rather close to each other, I would use the following method to find the closest intersections: | eval diff=abs(y1 - y2)
| sort diff
| head 1
| table _time, y1, y2, diff From there, you can use another diff (if needed) to calculate the actual difference between the numbers stored in the y1 and y2 fields. Search Ref: Function: abs Command: Sort Command: Head best regards,