Recently, when I have been using the dimension_group with type time, it has been reverting my dates back a day. For example, in my query I would have a column of dates depicting only the first day of the month. (ex: 2021-03-01, 2021-12-01). But when I input this column into the LookML dimension_group, I start seeing the dates with a day subtracted (ex: 2021-02-28, 2021-11-31).
Why does this happen? How can I fix this?
Best answer by KAEYVView original