In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Count consecutive days skip weekends

BosKev
8 - Asteroid

Hi,

 

How do I count the number of consecutive days without weekends? Thanks.

 

Employee Full NameWork DateDesired Out put Consecutive Days
A5/3/20211
A5/4/20212
A5/5/20213
A5/6/20214
A5/7/20215
A5/10/20216
A5/11/20217
A5/12/20218
A5/13/20219
5 REPLIES 5
apathetichell
19 - Altair

This is the easiest way...

john_watkins
11 - Bolide

There are many ways to go about this.  This way is very basic and works.  

BosKev
8 - Asteroid

@apathetichell Thanks, I forgot to mention there are multiple employees, the recordID tool is good solution but doesn't work if there are more than one employee.

BosKev
8 - Asteroid

Thanks @john_watkins , this works great.

apathetichell
19 - Altair

Yeah for multiple employees you can turn it into a (regular) macro and feed in the employee and  min/max date for each employee (which you get via summarize tool).

 

If you come back to that version - and need help implementing it that way, let me know.

Labels
Top Solution Authors