topic Re: Count dates in each Week Day in App Development

Count dates in each Week Day

gal_polak — Sat, 16 Nov 2024 06:31:49 GMT

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 — Thu, 21 Feb 2019 13:23:11 GMT

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 — Thu, 21 Feb 2019 13:25:53 GMT

May be like this

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

gal_polak — Thu, 21 Feb 2019 14:04:42 GMT

seems to work! thx!