Is there a function to return the last weekday?
Instead of:
relative_time(now(), "-1d@d")
Is there any notation to say workday or weekday?
That did not seem to work. Instead I used a case to check the day of the week:
| where Date > case(strftime(now(),"%w")="1", relative_time(now(), "-3d@d"), strftime(now(),"%w")!="1", relative_time(now(), "-1d@d"))
That did not seem to work. Instead I used a case to check the day of the week:
| where Date > case(strftime(now(),"%w")="1", relative_time(now(), "-3d@d"), strftime(now(),"%w")!="1", relative_time(now(), "-1d@d"))
@w-1d would take