Hi @morpheus2010 and welcome to the KNIME community forum
One possible solution is to use a moving average window to calculate the lowest 8 average position within your “Value” column. Then, keep only the lowest value using the -GroupBy- node.
There are two nodes for this in KNIME but only the more advanced -Moving Aggregation- node allows EVEN size sliding windows, i.e. 8 as in your case.
Please find below the workflow implementing your solution:
Hope it helps.
Best
Ael
PS 1: I didn’t see your previous post since I was already writing mine. Yes, it is exactly that.
PS 2: Thanks @takbb for the great component you implemented to convert data from the forum into a table. It works like a charm !