Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
hi @pinky1234 ,
Please use below expression.
sum({<date={"$(='>=' & Date(ReloadTime(),'DD-MMM-YYYY') & '<=' & Date(ReloadTime()-20,'DD-MMM-YYYY'))"}>}
tickets)
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