Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI initially did a descending sort before the summarize (to group the rows with the same count).. which created a simple error in that the summarize grouping function will automatically resort the list in ascending or descending. While it will probably work to put in second sort function after the summarize, it is much easier to put the summarize function first before the sorting function.
Here is my solution.
Here is my solution. Used a formula to rank count using the Multirow tool in Alteryx
This was nice and quick!