Date fields throwing error
My dimension group of date is apparently throwing errors when included in the dashboard. Can someone help me r...
Forum Posts
LookML architecture/organization (w/ multiple customers)
What’s been your experience in organizing your lookML, specifically when provisioning reports to different cus...
How to extend existing model from one connection to the other?
I can see the VIEWS and MODELS coming from the source through remote dependency, but I am not able to use EXTE...
Use different locales for each timeframes
Greetings!I am currently applying a locale to my dashboards. Everything is working fine, except for that.I hav...
convert utc_departure_date field in airport local timezone in Looker view
Previous year, the US based organization I work for launched in the Europe. While this was super exciting for ...
Convert UTC to local time zone in Looker (have bigquery database)
I am not able to convert my UTC timestamp column to a local destination timezone using a different column in m...
Aggregate awareness exact match
Hello all, I have order_item Explore with the below joins:order_item ----- (many-to-one) ----- order ----- (on...
Combining Different Dates into Looker Table
Hi Guys,I curious how to go about implementing counts/sums when I have different dates in my data.Data Structu...
LookML - filter measure by the dimension in another view
Context:View 1: Fact Sales Dimension: Date Measure: Total Sales View 2: Dim Calendar Dimension: Date Year Ques...
LookML Diagram
The base view is not the one highlighted in dark blue in the LookML Diagram for one of my explores. Not sure w...
LookML model join is using fields as numeric when they are both defiled as string
Hi All I am getting the following error in a LookML model on a join - it seems to be trying to join post codes...
How to get Filter's Start and End Date From Another View?
Hi guys, hope you are doing great. I would like to know if anyone can help me with my problem, but first, I wa...
difference between 2 timestamps in days in looker
How can I do difference between 2 timestamps from different views in looker? (My DB is Postgresql)Example:dime...
calculate customer repeat rates
I am trying to create a measure(customer repeat rates) something like this but did not got lucky so far, can a...
How does looker recognize Primary Keys when autogenerates code ?
Hello everyone,My question is: How does looker recognize Primary Keys when autogenerates code (after having cr...
How to add hours to my timeframe field?
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
convert my timestamp dimension group from utc to gmt?
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
Modelling Expansion Revenue SaaS
Hi everybody.I am currently struggling with defining and creating a specific metric for a SaaS business which ...
how to make case dimensions out of a column?
Does someone know how I can use this type of sql in Looker?Select , count(case when tickets= 'A' then id end) ...
How to add multiple values in multiple filters within the same field inside a view?
wanted to add something like this but not able to find a correct syntax--measure: total_revenue { type: sum sq...
Aggregate awareness - filter values
Do you know of a way to include multiple values in the filter of an aggregate awareness table, and get looker ...
How can the admin assign the managed_models permission set to a developer?
What are the steps to assign the managed_models permission set to the developer role?
Drilling into a Measure after it has been "Dimensionalized"?
Hi all! I am wondering if there is a way to preserve a Measure’s drilldown after it has been “dimensionalized”...
Join several views at once to an explore (making code DRY)
I have a model in which serveral explores repeat the same join logic. Imagine I have this diagram: table_a -> ...
Table Visualization for Daily Counts
Hello, I have a single table with multiple datetime columns that represent when a row in my table transitioned...
UTC date and hour data to different timezone based report
Need help with converting UTC date partitioned data into a different timezone based data/report. | date (DATE)...