I want to display sales from yesterday but the company is close Saturday and Sunday. So when the day is Monday I need to return Friday sales. But if the day is Tuesday I can return Monday sales.
Is there a way to do a conditional filter in Analytics ?
For example :
if today() == 'Monday' then filter q by 'Date' in ["3 day ago" .. "3 day ago"] else filter q by 'Date' in ["1 day ago" .. "1 day ago"]