Hey all,
I’m trying to figure out this weird error I’m getting. When I filter my dates with ‘is in the past 5 months’, I get the error `Query execution failed: - Invalid empty time zone`, but when I use a date range for the filter, there is no issue.
I looked into the SQL code behind the scenes, and it seems like Looker is using CURRENT_DATE(‘’) with an empty string for the ‘is in the past [x]’ filter. Has anyone experienced this? Any suggestions to still use the ‘is in the past [x]’ filter without having this issue.
Thanks!
Joe