Count dates in each Week Day

[gal_polak]

Hi all, 

I have list of items(challengs) that have start and end date, 

what i would like to do, 

is count how many challenges have start date in each week day , and how many have end date in each week day

so for example: i have challenge.enddate of 1/13/2019 which is Sunday,

and i want it to be counted only in sunday as 1 

is it possible?

[Anil_Babu_Samineni]

May be this?

Create field, If WeekDay field not available in the model like WeekDay(DateField) as WeekDay

Then, Expression as follows

Count({<WeekDay = {'Sun'}>} WeekDay)

[sunny_talwar · Accepted solution]

May be like this

If(WeekDay([Challenges.EndDate]) = [Week Day],
   Count(WeekDay([Challenges.EndDate]))
)

[gal_polak]

seems to work! thx!