Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am trying to calculate WTD where my week start date should correspond to Sunday and week end date should be Monday.
In the script , I have changed below:-
SET FirstWeekDay=6; // changed from 0 to 1 Vb test
SET BrokenWeeks=0;
Now I have proper week start and week end dates as follow:-
Here week start dates are for Sunday's and week end is Monday.
Now , what I want to show is a table with dimension as Date (only for Saturday i.e date corresponding to Saturday only ) and in measure, cumulative sum of entire week. (WTD- sum of numbers starting from sunday and ending at Monday). I tried using below expression but it did not worked:-
Sum({< Date_key={">=$(=Num(WeekStart(Max(Date_key))))<=$(=Num(WeekStart(Max(Date_key))))"}>} total_logged)
Can anyone please help ?
Just to add, I have other dates as well in my data model and in few charts I am displaying only Saturday dates as dimension in the visual. So, when I changed the value of set Firstdayofweek from 0 to 6 , it disturbed the other dates in the data model.
Please help ?I am stuck 😞
Can anyone please help ? Can we achieve it using peek and previous functions and create flags at backend end ?