Knowledge Drop

Filter On Current Week Of Year

  • 6 April 2021
  • 0 replies
  • 957 views

Userlevel 5

Last tested: Jan 21, 2019
 

Use a custom filter:

${week_of_year_dimension} = ceiling(diff_days(date(extract_years(now()),01,01),now())/7)

Here we're getting the difference in days between January first of this year and today and dividing that by 7 to get the number of weeks. We use ceiling to round it up so we get the current week.

 

This content is subject to limited support.                

 


0 replies

Be the first to reply!

Reply