ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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.
I'd reorder your tools and use a join tool to avoid having to update the filter expression.
