"This Month" date range on 1st of the month?
We pull almost all of our data in overnight or in the early morning hours for yesterday (or up to and including yesterday when replacing). When we use "This Month" or "MTD" date ranges, it works as expected until we get to the first of the month. At this point in time, most of our users are interested in reviewing the previous month in its entirety, rather than the current month, whose numbers won't start being pulled in until the next day.
Has anyone had a similar problem and come up with an elegant solution? A beastmode like this was the closest thing I could come up with, but when you take into account the timezone correction for daylight savings where we are located it becomes even more complicated. It also prevents users from being able to adjust the date range without having to disable a quick filter.
It seemed to me like this would be such a common issue that someone would have a creative solution by now.