How to do default selection in week

[#1]

Hello Everyone,

I have below scenario,

i am showing some values in table, when dashboard opens the table should show past 13 weeks values from this week.

if user selects particular week it should show past 13 weeks values

Please help me in that

Thanks

[Anonymous]

supose you have a field myweek you should use set analysis

e.g. sum({<myweek={>=$(=selectedweek-13)}<=$(=selectedweek))'>}sumvalue)

example with week today

sum({<myweek={'>=$(week(today()-13))>=$(=week(today())'}>}