Creating a line chart that is partly independent from time selection

[#1]

Hi all,

Im experiencing a  problem for which i dont have a solution. Im trying to make a graph that show the past 10 weeks of data when selecting a week. So if i select week 15 the chart should show week 6-15.

A basic exmapl to work with is in the attchement.

Any help will be greatly appriciated!

gr,

Aart

[tresesco · Accepted solution]

Try expression:

=sum({<Week={">$(=Max(Week)-10) <=$(=Max(Week))"}>}Number)

[#3]

Works like a charm! I really should read up on set analysis i realize now

Thnks for the fast response