community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Count Sundays, Mondays, Tuesdays,... in a month

Alteryx Certified Partner

Hey @Rawan

 

Have you got the file/workflow that has your holidays in?

Meteor

here is the list, and i have it in the workflow that i submitted in my previous post.. thanks plenty..

 

Rawan

Alteryx Certified Partner

I think this is what you're looking for

Meteor

@LordNeilLord

 

I am sorry for the confusion that i caused.  I only meant with this "1-1", that I want to subtract the flag (1 ) from the Ct of Mondays, which is the Holiday Day. Thanks so much for helping me with this, and also for teaching me great things in Alteryx..

 

DateMonthsDayHoliday FlagCount_SundayCount_MondayCount_TuesdayCount_WednesdayCount_ThursdayCount_FridayCount_Saturday
5/1/20185Tuesday04455544
5/2/20185Wednesday04445544
5/3/20185Thursday04444544
5/4/20185Friday04444444
5/5/20185Saturday04444434
5/6/20185Sunday04444433
5/7/20185Monday03444433
5/8/20185Tuesday03344433
5/9/20185Wednesday03334433
5/10/20185Thursday03333433
5/11/20185Friday03333333
5/12/20185Saturday03333323
5/13/20185Sunday03333322
5/14/20185Monday02333322
5/15/20185Tuesday02233322
5/16/20185Wednesday02223322
5/17/20185Thursday02222322
5/18/20185Friday02222222
5/19/20185Saturday02222212
5/20/20185Sunday02222211
5/21/20185Monday01222211
5/22/20185Tuesday01122211
5/23/20185Wednesday01112211
5/24/20185Thursday01111211
5/25/20185Friday01111111
5/26/20185Saturday011111 1
5/27/20185Sunday011111  
5/28/20185Monday1 0111  
5/29/20185Tuesday0  111  
5/30/20185Wednesday0 0 = Ct of Mondays - Holiday Flag11 

 

5/31/20185Thursday0    1  
Highlighted
Alteryx Certified Partner

Try this one

Meteor

@LordNeilLord

 

Thanks again, it works great! 

Labels