Given the following sample data
time,id,part1 2022-08-16 17:35:00,7,7.18 2022-08-16 17:40:00,7,0.18 <--BB - this bad boy 2022-08-16 17:45:00,7,7.91 2022-08-16 17:50:00,7,8.57 2022-08-16 17:55:00,7,8.57 2022-08-16 18:00:00,7,8.61
row indicated as BB is an anomaly and would like to eliminate it from summation query. Any drop in that value indicates a failure & restart in the ioT
In sql server for example you can use the lead() function. Is there such a thing in flux. or previous() type of thing?