Ranking is used to display data in a ranked order. We can rank a list by group using the Multi-Row Formula in Alteryx. I am excited to show how easily this can be done. In this blog, I am using a list of daily sales, accounts and category, and I would rank sales from highest to lowest for daily sales.
2. The steps in Alteryx are as follows:
a. Ensure that the data is sorted by date. Also the sales are sorted from highest to lowest for the daily sales.
b. Add in the Multi-Row formula too.
3. Select the field Dates as we want them to be grouped (see selection).
4. To rank the sales, write the expression:
if [Sale] != [Row-1:Sale]
then [Row-1:Rank]+1
else [Row-1:Rank]
endif
5. A new column called “Rank” is created.
