20221008 Pikairos Mean of the n lowest consecutive hours

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?

Short example (only one day of data):

|Timestamp|Value|

External resources

• Mean of the n lowest consecutive hours