Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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)