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