Adapting the visualisation to a selection

[khaoula_agazzar01]

Hello guys,

I need you help.

i have created a table in my visualisation that contains some indicators for the last 3 weeks.

when i do a selection on a month that doesn't contains this last 3 weeks, it doesn't work.

For example, my last for weeks are S11,S10,S09  (the  last 3 weeks of march),

But when i select january, it show S11,S10,S09  again and without value for my indicators.

I want to have the results for the the last 3 weeks of the month selecting january.

Than you for your help;

[Digvijay_Singh]

Looks like you have created your indicators in the script based on today() or present date. The dynamic identification of last three weeks based on your selection can be achieved using set analysis in the chart expression, something like Sum(Date ={">$(=WeekStart(Max(Date),-3))"}Sales)