Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

add a sequence number based on a grouping of columns

ingafly2
5 - Atom

I have tried doing this in a multi-row formula and am not able to achieve my results. Basically what I am trying to do is add an overall grouping for each time the type of Stage History occurs, I'm trying to add a sequence to both the Stage History record (prior record) and all of the subsequent records whose create date appears between the create date and end date of the stage history record (I have already created the two ordering columns on the right to have an overall order and then a sub order of how the records are occurring)2022-03-03_10-59-07_example.jpg:

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@ingafly2 ,

 

Please use my CReW Group By Record ID macro:

 

https://community.alteryx.com/t5/Public-Community-Gallery/Grouped-Record-ID/ta-p/903356

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels