Set Analysis Expression to count based on DayName

[Mdjenkins]

Good afternoon guys,  

I have a data model that contains the following:

CallID      Date

1               4/1/2019   (Monday)

2               4/2/2019   (Tuesday)

3               4/3/2019   (Wednesday)

4               4/4/2019   (Thursday)

5               4/5/2019   (Friday)

6               4/6/2019  (Saturday)

7               4/7/2019  (Sunday)

Now I want to do a count of CallID where the DayName of Date is either a Saturday or a Sunday.

So the answer would be 2 because CallID 6 and 7 match the criteria.

Does anyone know how I would do a set analysis expression on a Count function to only include Saturday and Sunday? 

[Anil_Babu_Samineni]

My suggested to go and create weekday field lokee Weekday(Date) as weekday Then, expression should be

Count({<weekday={'sat','sun'>} CallerID)

Else, use expression like

Count({<Date={"=match(weekday(Date), 'sat', 'sun')"} >} CallerID)

[sunny_talwar · Accepted solution]

May be this

Count({<Date = {"=Match(WeekDay(Date), 'Sat', 'Sun')"}>}CallID)

[Mdjenkins]

For some reason, this method always returns all days. It does not limit the scope to Sat and Sun

[Mdjenkins]

Hey guys, this is the solution.  I had mixed up the date fields