dynamic Date for 20 days

[pinky1234]

Hi Team,

I have the data like shown in below. date and Tickets columns. I want to know how many tickets we got it in 20 days. Say for ex: if I refresh the report today I want to know what happened in  last 20 days from today. Like wise I need it dynamically date should change when ever refresh the report. Can any one please help me?

Date	Tickets
9/1/2021	1
9/2/2021	2
9/3/2021	5
9/4/2021	6
9/5/2021	1
9/6/2021	2
9/7/2021	1
9/8/2021	1
9/9/2021	2
9/10/2021	1
9/11/2021	3
9/12/2021	2
9/13/2021	0
9/14/2021	1
9/15/2021	1
9/16/2021	0
9/17/2021	1
9/18/2021	0
9/19/2021	0
9/20/2021	1
9/21/2021	2
9/22/2021	1
9/23/2021	1
9/24/2021	1
9/25/2021	1
9/26/2021	1
9/27/2021	1
9/28/2021	1
9/29/2021	1
8/1/2021	1
8/2/2021	1
8/3/2021	1
8/4/2021	1

[abhijitnalekar]

hi @pinky1234 ,

Please use below expression.

sum({<date={"$(='>=' & Date(ReloadTime(),'DD-MMM-YYYY') & '<=' & Date(ReloadTime()-20,'DD-MMM-YYYY'))"}>}
tickets)

[AshutoshBhumkar]

Hi,

Maybe something like below.

sum({<Date={">=$(=Date(ReloadTime()-20,'MM/DD/YYYY')) <= $(=Date(ReloadTime(),'MM/DD/YYYY')))"}>}Tickets)

Which will give data from 11-Sep-21 till today (Last 20 days)

Thanks,

Ashutosh