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?
Solved! Go to Solution.
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?
Hi, You might want to add ‘convert_tz: no’ as a keyword to your dimension definition this should fix it. kr Victor