I am calculating the delayed time for flights using the estimated_arrival_time and filed_departure_time.
i noticed that sometimes (30% of the time) the estimated_arrival_time gets updated and then revert back to the original (usually within 5 minutes)
which will give me a wrong delayed time.
the status will be like this:
On time => delayed => on time
what is the proper way to keep track of the estimated_arrival_time? How do i ensure that the estimated_arrival_time will not give me a fake delayed time?