Lead() to get next "row" value

Greetings,

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?

Thanks !

I think I need to go with difference in flux

:hatched_chick: