Last Weekday in filter a board

[angupta]

Hi, 

We send daily reports in the form of pdf (of dashboards) to our client. We do it in the automated way, for that we use DateTime field as filter and using "Time Frame".  Right now, we use "Yesterday" as a filter (see ss) checking day at the script level to not send report on Sun-Mon (respectively for Sat-Sun data).

Can we have "Last Weekday" in here or a piece of code I can put in Advanced Filters which can give me Last Weekday. (Mon to Fri).

It will be great help, if we can have something like that.

Thanks,

Animesh

[DRay · Accepted solution]

Hi @angupta,

Thank you for reaching out. Can you take a look at this post and let us know if it solves your need?

https://community.sisense.com/t5/knowledge-base/filter-for-last-working-day/ta-p/8710

Thank you.

[angupta]

Hi @DRay ,

I tried the solution and it works as I wanted. Thanks for the help.