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

Rolling/Running Maximum

Giles
6 - Meteoroid

Alteryx Newbie, here. Trying to add a column which will contain a rolling maximum (MAX_TAG) of the contents of another column (TAG), e.g.:

 

MAX_TAG.jpg

 

Presumably a multi-row formula is the place to start, but could do with some assistance..

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

If [row-1:Max_Tag] > [Tag] then [Row-1:Max_Tag] else [Tag] endif 

 

The above should do the trick within the multi-row formula tool.

 

Example attached.

 

Ben

 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@BenMoss is quite right.

 

You might also want to view this interactive lesson:  https://community.alteryx.com/t5/Interactive-Lessons/How-to-Fill-Your-Data/ta-p/82872

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Giles
6 - Meteoroid

Thanks, both. =)

Labels