Help with Sample Data on the forum

[aworker]

Hi @takbb

Thanks a lot for the great component you implemented to convert data from the forum into a table. It works like a charm as demonstrated below !

Mean of the n lowest consecutive hours

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: [image] Hope it helps. Best Ael PS 1:…