I want to create categories based on dates, but the dataset is not filtered correctly when using pre-defined dates range like current week, next week or last week.
For instance, current week does not include feature dated of 5/31/2020 8:00 PM. This feature is filtered in the last week category and those dated of 6/7/2020 8:00 PM are filtered in the current week instead of the next week.
In the doc, its written that the current week start sunday at 12:00 AM.
<<Week—A week starts at 12:00:00 a.m. on Sunday and continues for 7 consecutive days, ending at 11:59:59 p.m. on the seventh day, which is Saturday.>>
Why the starting week date is not sunday at 12:00 AM in my dashboard?