Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to create a bookmark for the previous 4 weeks, but in my case the week is the first day of week.
Ex: Today is 01/04 and the Weekstart(today) is 28/03. I want a filter with 28/03, and 21/03 and 14/03 and 07/03.
Thanks
Dora
One way to do this is to define a relative week in the script:
Div(WeekStart(Today()) - Weekstart(Date),7) as RelativeWeek,
Then it becomes a simple selection of 0 to 4, that you can save as a bookmark.