Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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