Knowledge Drop

Filter On Current Week Of Year

  • 6 April 2021
  • 0 replies

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!