Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
would you be able to send sample code??
This works, thank you!