Don't create new fields. If you use trend and relative operators correctly, you should be able to express this. You just need to make it a whole other OR condition to the "created yesterday" line. Don't click the OR at the end of the condition line. Click the NEW CRITERIIA button at the bottom of the report builder!!
Anyway... this will make a whole new query condition that selects anything from three days ago so long as its also on a Friday, Saturday, Sunday, or Monday.
Knowing the Trend operator is critical for this kind of complexity. I made a video about it here:
I have not seen anyone post a solution yet so giving it a try. I needed a report that on Monday would show just Saturday and Sunday (I could have included Friday but was not needed). Following is what works for me and will give credit for the foundation being provided by Robert Fedoruk but the results I was getting was blank. So, tweaked the concept a little and this produced the results I was looking for. Sharing and would like to know if this helps/does it for anyone.
Let me know if it works for you?
Hi,
Thank you for the solution @Uncle Rob . I had the same problem, though your solution didnt work as it is but a little fine tuning helped me get what I need.
Here's how you can include cases where: IF day=Tue-Fri THEN case created date=yesterday ELSE IF Day=Mon then Case created date = Fri-Mon
Hope it helps!
Thanks
