Hi,
I have created a table and line Chart to track the number of tickets closed on a daily basis and the cumulative number of total tickets closed, please see below:
Date, Tickets Closed, Total Tickets Closed
01/09/2023, 1, 1
02/09/2023,9, 10
03/09/2023,20, 30
where [Total Tickets Closed] = rangesum(above(sum([Tickets Closed]),0,rowno()))
Is it possible to get the date where the [Total Tickets Closed] was a certain value? For example, [Total Tickets Closed] =10 returns 02/09/2023. I am having a little trouble with the rangesum function.
Thanks,
Amy
