We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

Risk based sampling



I have 30 employees, each with 20 expense report numbers, each report number 5 types of expenses attached to them, all with different amount spent. Hence a total of 3000 line items. Of the 3000 line items I want to samples, ensuring that each employee with at least each expense type that has the highest amount spent, without overlapping reports, to be selected as my samples. 

8 - Asteroid

Hi @JingYih_Herbalife ,


I think an iterative macro will be your solution, but can you elaborate further? For your sample, do you want the highest amount spent for each of the 5 expense types for all 30 employees (150 records)?