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