Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Workaround to 30 times Multirow?

df
8 - Asteroid

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.

grafik.png

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

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
ACE Emeritus
ACE Emeritus

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

Labels