This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Looker dimension_group with type time is changing my timestamps back a day, why is this happening?

Posted on 12-13-2021 01:21 PM
blee
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

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 Solved
0 3 139
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
KAEYV
New Member
Reply posted on --/--/---- --:-- AM

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

View solution in original post

Jump to Solution
3 REPLIES 3
Top Labels in this Space
Top Solution Authors
View all