This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
As shown in the attached I have been given the data that shows when sales orders were changed, their old request dates (due dates) and new request dates. I cannot figure out how to have Alteryx compare rows that have the same sales orders and then determine if it was the first change made to the order, the second, third, etc. I'm getting close to manually going through the data, please stop me! Thank you! (Oh and all data in the attached is fictional in case someone from my company is wondering.)
I think a "Multi-Row Formula" tool will do the trick. Sort the data first and then use a Multi-Row Formula to add a change flag to each row (grouping by the Sales Order field to start the flag over at 1 for each new SO).
After that a Summarize tool can take care of the aggregation for charting.
Hi @PMurphy4, you could also use the Tile tool and group records within them. As shown in the image below, I group the data based on Sales Order column using the Tile tool and it numbers the value within it.
Thank you @AbhilashR! I see this Tile tool can work as well. I'm trying to wrap my head around why the tool requires you to sort the sales order and then the change date? Tile_Num categorizes the field you choose but how does Tile_SequenceNum know the order without telling it which field to utilize for sequencing? Thank you again!