I set up a dashboard to view the total amount on invoices for last week. I used the @weekstart-1 and @weekend-1 for the filter.
It worked fine, however I’m running into an issue on a week where the moth changes in middle of the week. i.e. March 1 was on a Wed. The filter will only include anything from March 1 till the end of the week.
What if you set the Value 2 = @WeekStart + 6?
What if you set the Value 2 = @WeekStart + 6?
That indicates “this” week start plus 6 weeks. I need last weeks numbers.
The GI I was basing it on had a period condition. I removed that, and it’s working now.
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.