Alteryx Designer Desktop Discussions

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

Filter for the last 3 workdays of the month

pmelikian
7 - Meteor

Hello,

 

Im having trouble writing a custom filter forumula to include the only the last three business days of the month. 

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @pmelikian ,

 

Since we don't have a specific function to count week days, I've created an example to show how we can do that with a workflow. I'm filtering the 3 last workdays from every month.

 

Take a look and let me know if this makes sense to you.

Best,

Fernando Vizcaino

DavidP
17 - Castor
17 - Castor

This gives you the last 3 working days of a given month. You can use it with a join tool to join to your dataset.

 

DavidP_0-1581630921363.png

 

Labels