Filter for the last workingday in a table component

[Peter]

Hi, I need ideas.

I want to put two filters on top of the table:
Today
Last working day.

Any idea how I could do that. Any strategy, any fields that could help.

So like “workday is yesterday, when it is not a monday - otherwise workday is 3 days ago”.

So should work with the filter tab above the table component.

Thanks

[Peter]

I can answer it myself.

First, you define a new date field:

Note: DAYOFWEEK({Workday} = ‘Friday’) should actually be DAYOFWEEK({Workday} = ‘6’) - as the number of Friday is 6.

In the table filter tabs, you do it like this:

On Monday, we will see if it really works…