Weekday in set analysis

[pascaldijkshoor]

Hello,

I want to include certain weekdays in set analysis. For example that it only shows data for monday. These are the formulas i have tried, but both don't work:

Count ({$<weekday={"Ma"}>}LOAD_INDEX) 

Count ({$<weekday(L_begin_date.date)={"Ma"}>}LOAD_INDEX) 

Making a filter with weekdays is not an option for me.

Thanks in advance

[qv_testing · Accepted solution]

Create derived column in the load editor, like below

Load  L_begin_date.date

          Weekday(L_begin_date.date) as WeekDay  // Derived column

From table;

[qv_testing]

would you be able to send sample code??

[pascaldijkshoor]

This works, thank you!