Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
Count({<Date = {"=Match(WeekDay(Date), 'Sat', 'Sun')"}>}CallID)
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)
May be this
Count({<Date = {"=Match(WeekDay(Date), 'Sat', 'Sun')"}>}CallID)
Hey guys, this is the solution. I had mixed up the date fields