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 have:dimension: fl { type: string sql: CONCAT('flt-', ${departure_date}, '_' , ${oa.iata}, '-', ${da.iata}) ;; } dimension_group: departure { type: time timeframes: [ raw, time, date, week, month, quarter, year ] sql: TIMESTAMP (${TABLE}.departure_...

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-...