Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Risk based sampling

JingYih_Herbalife
8 - Asteroid

Example:

 

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. 

1 REPLY 1
drew9
9 - Comet

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)?

Labels
Top Solution Authors