i have a dataset with hourly consumption data. I need the mean result of the lowest 8 consecutive hours in the weekend. With Group by node it´s easy to get the mean of the hole weekend but how i can get mean of the lowest 8 consecutive values?

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: