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.
User | Count |
---|---|
106 | |
85 | |
76 | |
54 | |
40 |