This content has been marked as final. Show 3 replies
I'm trying to figure out how to build an expression which does a count of an ID for the past 30 working days. I created a WeekEnd flag but I'm not getting the results I expect:
count(distinct(if(Date >= Today()-30 AND WeekEndFlag = 0,ID)))
I believe this is just omitting weekends in the past 30 days. How can I get the past 30 working days (Mon- Fri)?