How to eliminate a value if it's too much lower than the previus value?

[brunolelli87]

Hello guys,

I've a problem with my DataBase and I need your help to solve it.

I would like to show the number of planes flying for a specific airline per minute, and in order to do that, I'm using the following expression:

=count({<DATA ={"$(=Date(Max(DATA),'DD/MM/YYYY'))"},NCIA={'AZU'}>}TAIL)

But due to a time issue with my database, sometimes I'm not receiving the accurate number and the output is almost reduced to zero.

I'm expecting something like this:

Basically, I'm wondering how to eliminate the values that are more than 50% lower than the previous value.

This is how my database looks like:

25/03/21;22:29;AZU;AZU4376;AT76;PR-AQQ;CNF;UDI;-19.1421;-47.5004;272;18025;255;0;0
25/03/21;22:29;AZU;AZU4167;A20N;PR-YRB;REC;MAO;-7.4615;-39.1616;281;36025;445;0;0
25/03/21;22:29;AZU;AZU4771;AT76;PR-AQR;VCP;JOI;-25.2657;-48.4467;182;17700;267;0;-512
25/03/21;22:29;AZU;AZU4352;A20N;PR-YYG;REC;SLZ;-5.9628;-37.9439;298;37975;434;0;0
25/03/21;22:29;AZU;AZU4412;A20N;PR-YYJ;CNF;VIX;-20.4233;-40.4963;99;4850;263;0;-1344