Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm creating Bookmarks with following selections. Those selections are based on Year, WeekNumber etc. after a week when a new week is added and I go to the bookmark I do not see the current week as the latest but the one selected at the time Bookmark was created.
Is there a way to point Bookmarks to current week?
The bookmark can't be dynamic like you want. But there is a way to achieve the same. Create an IsCurrentWeek field in the script.
LOAD ..some_fields..
, WeekNumber
, if(week(today())=WeekNumber,1,0) as IsCurrentWeek
FROM ...;
Then redefine your bookmark so that includes the selection of 1 in the IsCurrentWeek field. This field will be updated every reload so your bookmark won't have to change anymore.