We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to select last 5 days' records from each calendar month of given data set?

shivakumarmanian
6 - Meteoroid

Hi Team,

 

I have a bunch of sales records containing the sales dates.  I need to select all the records of last 5 days of each calendar month.  I would like to have the report saved in a file with Customer Name, Sale Date (only those records that are sold during the last 5 days of each calendar month).

 

Kindly help,

Thanks,

Siva

12 REPLIES 12
Peachyco
8 - Asteroid

@TMHC : Here would be my approach to solving it:

Untitled.png

 

This is what my input looks like:

Untitled2.png

 

This is the resulting dataset. You can just unselect the Grouping Date and the Record Count using the "Select" tool.

Untitled3.png

 

TMHC
5 - Atom

Would you be able to provide the coding to be able to do this?

Peachyco
8 - Asteroid

@TMHC : Here it is. Lemme know if it works for you. 😊

Labels