Hi this problem is NOT SOLVED. Please do not mark it as solved. I am having to same issue. To be clear, any case with DAILY data is NOT fixed with a solution utilizing calculated fields.
The date filter, when using relative dates, is set to UTC. Why? This is a terrible take for production. 4pm PST rolls by, and some people are wondering why the relative date which says “previous day” is showing incorrect data. Well, it is showing data that is technically today, because 4PM PST is 12AM UTC.
I would like to hear about when this can be changed, since no solution seems to be present online. @SeanBoon please let us know, it’s coming up on 12 months.