default

[#1]

Hi Guys,

is there any issue with rolling 6 weeks logic of mine. it works fine sometimes and sometimes does not work

='("' & concat({<MonthAndYearID={">=$(vprevweek)<=$(curweek)"}>} distinct WeekAndYear,'"|"') & '")'

$(vprevweek)=max(MonthAndYearID)-20
$(curweek)=max(MonthAndYearID)-17

Same logic works when i click the button of rolling 6 weeks but on open of document i kept same logic so that on open of my dashboard rolling 6 weeks get selected. but it does not work there. any idea?did you face any such issues with rolling week concepts?

[Anonymous]

When you say ".... on open of document.... " does that mean you are using On Open triggers ? 

If so and you are using the AJAX client, then do be aware that On Open triggers may not work.

[#3]

it does not work in desktop version

[#4]

on double clicking only rolling 6 weeks button works, on single click it shows wrong value

[Anonymous]

what is the logic of rolling 4 weeks?