Forum Discussion
GJeanes1
2 years agoFrequent Visitor
Using Offest by the day
Hello all! So every day I have to click Filters --> Filters on this page and select what day it is, so today I checked the box for October 5th. I have day/month filters so that we can see the n...
GJeanes1
2 years agoFrequent Visitor
I have been researching how to have an offset calendar and have rolling totals, however, my issue is I am looking at an automated rolling total for the current year and for previous years,
So if today is 10/10/23, then the code would read total data for this year between 1/1/2023 to today, then look for last year's data between 1/1/2022 up to today's date last year (10/10/22),
I also need the dates to be automated for previous years so that when tomorrow comes, the previous year's data would look at "today (10/11/23)" so I am not manually clicking which day it is.
Then continue looking at those dates and years back to 2018
Please let me know how to accomplish this.