I’m trying to set up a dynamic time filter for transactions, but cannot find the appropriate way to express it.
I need to compare a week from this year, to last year, with a starting date difference of 1 day.
EX: Week of 4.11.22 (mon-sun), compared to 4.12.22 (mon-sun)
So 1 year ago, plus 1 day, range of 7 days from there. This would allow me to schedule a report with this years information, as well as the relevant LY data to compare it with.
Anywhere I can start? I’m not all that savvy, but figure once i have it set I’ll be golden.
How to set a transaction date filer that's dynamic. 7 day span - 1 year ago, starting one day later. EX: (Week of 4.11.22, compared to week of 4.12.21)
This topic has been closed for comments
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.