Alteryx Design Pattern: Get the Top X Number of Values
Joshua Burkhow
Oct 25
Use Case:
You want the top paid sales person per region or the top product by sales or anything of the sort. By using the combo of sorting and the sample tool you can get exactly that! In this example below I wanted the top selling product for each store on Saturdays.
Steps:
- Input Data
- Sort by field you want to sample
- Sample Top X values, Set group by to pick X number of values by each of the items in that group (ie Stores)