rolling seven days in timescript

[#1]

hi i have the following expression in the front end.

i would like to add it to the timescript insteas.

sum({<Leveransdatum={">=$(=AddMonths(Max(Leveransdatum-6),0))<=$(=Max(Leveransdatum))"}>}[Levererat Antal])

does anyone have a rolling seven days in their time script.

would today() -7 as R7_days be the equivalant?

it would be much better in my front end to have [Levererat antal] * R7_days as i have done for the r12 month and R13- R24 months as well.

Best,

Brad

[swuehl · Accepted solution]

For a rolling 7 days flag, you can use something like

     if(Leveransdatum >= today()-7, 1,0) as R7_days