Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

Rawan
7 - Meteor

Hello everyone,

 

I am wondering if there is a way to count how many weekdays in a month, but each weekday separate on a daily basis. here is an example of what i did in excel to achieve this:

 

5/1/20184455544
5/2/20184445544
5/3/20184444544
5/4/20184444444
5/5/20184444434
5/6/20184444433
5/7/20183444433
5/8/20183344433
5/9/20183334433
5/10/20183333433
5/11/20183333333
5/12/20183333323
5/13/20183333322
5/14/20182333322
5/15/20182233322
5/16/20182223322
5/17/20182222322
5/18/20182222222
5/19/20182222212
5/20/20182222211
5/21/20181222211
5/22/20181122211
5/23/20181112211
5/24/20181111211
5/25/20181111111
5/26/20181111101
5/27/20181111100
5/28/20180111100
5/29/20180011100
5/30/20180001100
5/31/20180000100

 

I am not sure if it is doable in Alteryx, but I am hoping it is..

 

thanks in advance

Rawan

15 REPLIES 15
LordNeilLord
15 - Aurora

Hey @Rawan

 

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

Rawan
7 - Meteor

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

 

Rawan

LordNeilLord
15 - Aurora

I think this is what you're looking for

Rawan
7 - 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  
LordNeilLord
15 - Aurora

Try this one

Rawan
7 - Meteor

@LordNeilLord

 

Thanks again, it works great! 

Labels