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.

Sample on Month

bighead
7 - Meteor

Hi- 

 

Is there a way to sample data based on the month? I have sales data for all of 2023 and have added a formula to create a column with the month based on the invoice date. Now I need to randomly select 3 months out of the year to test. Here's what I have so far but I think there's a cleaner way to do this. Note: for the random sample % I used 'random N% of records' at 25% since I needed 3 months.

 

Screenshot 2024-05-13 141905.png

 

 

 

 
 

 

1 REPLY 1
AGilbert
11 - Bolide

I'd reorder your tools and use a join tool to avoid having to update the filter expression. 

 

Screenshot 2024-05-13 133920.png

Labels
Top Solution Authors