LOADING

Type to search

Design Patterns

Alteryx Design Pattern: Get the Top X Number of Values

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.

solution3.png

Steps:

  1. Input Data
  2. Sort by field you want to sample
  3. Sample Top X values, Set group by to pick X number of values by each of the items in that group (ie Stores)
Tags:

Leave a Comment

Your email address will not be published. Required fields are marked *