Workaround to 30 times Multirow?

[df]

Hello community,

I have a data-table with this columns: Timestamp, Value and Event(flag)

First i want to calculate the average X Min (Rows) before the Event. [The Variable XMin is the same for every Event then]

Here i used 5 min for everything. Its just "Nice to have" if you could solve this with a Paramter XMin since the first formular can easily be adjusted.

The "real" problem comes next.

i want to calculate the average of current row to row+4

then average row+1 to row +5

then average row+2 to row +6

and so on (until i have 30 averages)

Is there a way to do this without 30 multirow-formulas?

attached the workflow with testdata.

[BenMoss]

Yes there's definitely an easier way to do this. I worked on a similar project about a year ago. I'll try and rustle something up for you given your sample data.

Ben

[BenMoss · Accepted solution]

So here's a example of part B, i've done it with your sample data looking between the current value and +1 through to +10 (you can adjust the min max look forward very easily.

Not to clear what you mean in the first part, but you said this should be relatively straight forward for yourself anyway.

Ben