Passing date dynamically from filter panel to report

[beskqlik]

HI 

I have date column.I am trying to 30 previous dates when selecting a date at filter panel.Like if i select May 10 2019 at filter. Below at report i should get dates.Can any one suggest as how can i get it

11-Apr-19
12-Apr-19
13-Apr-19
14-Apr-19
15-Apr-19
16-Apr-19
17-Apr-19
18-Apr-19
19-Apr-19
20-Apr-19
21-Apr-19
22-Apr-19
23-Apr-19
24-Apr-19
25-Apr-19
26-Apr-19
27-Apr-19
28-Apr-19
29-Apr-19
30-Apr-19
1-May-19
2-May-19
3-May-19
4-May-19
5-May-19
6-May-19
7-May-19
8-May-19
9-May-19
10-May-19

[Vegar · Accepted solution]

You can fetch the last 30 days in your expression by using SET analysis.
Try something like this, assuming SUM(Amount).

Sum({<
Month, year, week, yearmonth,
DateField={">$(=max(DateField)-10)<=$(=max(DateField))"}
>} Amount)

[beskqlik]

Wow, its working. Thank you very much

[Vegar]

Typing 30days writing code for 10 days🙊🙉🙈

I'm still a bit sleepy this morning.

Glad it worked out for you.