[Solved] Week of year over Week of year comparison

[JakubD]

Hi,
We very often track our metrics by Week of year and I’d like to create table where I will be able to compare values with the previous year.

But also I’d like to display only last X week numbers of year based on current week number.

Let’s say it’s week 4, year 2019 and I want to display only last 3 week numbers: 4, 3, 2 for 2018 and 2019.

The next week I will want to see only week numbers: 5, 4, 3 for 2018 and 2019

I was thinking about custom filter but there is no extract_week function.

How would you approach this? I’ll appreciate any suggestions.

Thanks