Show the last N weeks trend

[andreazambon]

Hi there. 

I show you a sample of the report i'm building. 

As you can see, I want to show a trend in my graph. In the left column we have a date filter with years, months and weeks.

Now, the graph should:

• be indipendent from the date filter (done)
• show only the last N weeks (format years.numweek) from today. So in this case, the trend I need to see starts from 2023.03 to 2023.07

The first condition is quite easy, working with relationship. The second one is tricky for me and it is the one's which I need your help.

[andreazambon]

Ok, you filtered the date. Nice idea 😉

[FreemanZ · Accepted solution]

hi @andreazambon 

try to feed the filter pane with the Date column and choose "Relative Date", in the last 5 weeks, like: