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.
Previous year, the US based organization I work for launched in the
Europe. While this was super exciting for the company, it came with a
whole lot of new data modelling challenges, one of which was handling
timezones.Prior to this launch, we stored ...
I am not able to convert my UTC timestamp column to a local destination
timezone using a different column in my BigQuery database.The complete
scenario is, I have a column timezone in one my destination table in
which I am trying to convert my curren...
My dimension group of date is apparently throwing errors when included
in the dashboard. Can someone help me resolve this issue?the field looks
like (using bigquery db):inserted_date{type: timetimeframe:
[raw,time,date,week,month,quarter,year]sql:
${...
I have a column with few name values which are string basically and I
need to just rename them so that it shows differently in the dashboard
which I am preparing using LookML. The scenario is as follows--This is
what I have( the names are as follows-...
Is there any update for this @LookerExperts ?Can we format our
timestamps inside the dimension_group using value format or something
yet in LookML? If not, is there any plan to release that kinda update by
looker?Would really appreciate if you have a...
Sounds great @vfx1 @fabio1. Really appreciate you guys!I was wondering
if I have to use the datatype:date then I won’t be able to use the
dimension group right? I can only create a normal dimension out of it!!
Actually, the code did not give any error but I got the null values.I
tried to run this--dimension: airport_timezone_actual_arrival { type:
date description: "Actual arrival date (Airport timezone)" sql: ( With a
as (select ${actual_departure_raw} as...