community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Rolling/Running Maximum

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..

Alteryx Certified Partner
Alteryx Certified Partner

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

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@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 reboot. Order shall return.
Meteoroid

Thanks, both. =)

Labels