Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
For a rolling 7 days flag, you can use something like
if(Leveransdatum >= today()-7, 1,0) as R7_days
For a rolling 7 days flag, you can use something like
if(Leveransdatum >= today()-7, 1,0) as R7_days