Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be like this
If(WeekDay([Challenges.EndDate]) = [Week Day],
Count(WeekDay([Challenges.EndDate]))
)
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)
May be like this
If(WeekDay([Challenges.EndDate]) = [Week Day],
Count(WeekDay([Challenges.EndDate]))
)