Creating views in loop
Hello!I’m completely new to Looker, and have just about one week of experience. So, if the questions seems obv...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
[Bug] Custom Dimension with Timezones - apply timezone after truncate to date
So I know Looker suggests go through support for bug report. But I’ve reported this bug and all I received fro...
Is there a way to sum count_distinct measures in an aggregate table?
Looker doesn’t allow count_distinct measures in aggregate tables (unless the table is an exact match to the qu...
Not able to create a new LookML Project
Hi All,I am not able to create a new LookML Project. I am not getting that button to create New LookML Project...
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 to get the dialect of a query in Looker
Hi Looker Team,I have a concern regarding the looker queries. Issue is, if I have look created from an oracle ...
Dynamic Cohorts
Hello,Our team is currently working on several requests that involve the ability to create custom cohorts. Her...
Filtering multiple columns
Hello, I have an issue that I am trying to solve. I have looked at multiple thread on the forum, but I have no...
Is there a way to search which explores/looks include a particular dimension?
i am trying to verify which explores/looks include a particular dimension and hoping there is an easier way to...
Avg for past x months weekly
Hi, below is my data tables I have.table1:sku_id dateval sales_data ab124 20210603 10 ab124 20210502 20 ab123 ...
Cleaner where conditions with dates with Bigquery Explore
Hey everyone!I’m a data scientist/engineer who is pretty new to Looker. Currently I’m trying to use Looker Exp...
Calculating distance from a dynamically selected location
Sometimes you might want to plot data points on a map that are within a specific distance from a dynamically s...
Using Link in HTML
Hi,I have an error with using Link and HTML at the same timeThis is how my lookml goesdimension_group: Today_d...
Implementing UNION on distinct partitioned tables
Hi all,ContextWe have several distinct apps that we track with Firebase. We connected Firebase to Google BigQu...
Period over Period week of year
HelloPlease, from a custom filter, the user chooses a date interval I want to compare the number of this week ...
How to dynamically hide or select dimensions (columns) from visualization?
Hello,I would like to have a visualisation with multiple dimensions (say A, B, C & D) and related measures (sa...
Joining 2 tables without duplicating the same entries associated
I have 2 tables (see below): Whats the best way of joining them so I can have consolidated Customer ID list (1...
How to manage connection with daily log files?
New looker user. Normally I have a data person to rely on. I’ll have multiple models under 1 project. I have c...
Period over Period with weekday number
Hello, I would like to calculate the period over period with weekday number by letting the user choose the dat...
Can we login into looker through command prompt
Hi Team,Can anyone please share me the code/batch script to login into Looker through command prompt.If there ...
How to use views with multiple database tables in same model
@Jeff_Garcia , We are facing the same issue. We have created multiple views files using derived table from a m...
Joins within an explore work in development mode but not in "normal" explore mode
I have database with multiple tables and I am looking to join columns from the different tables together. I ha...
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...
drill_fields Primary Key
Hello everyone!I’ve seen that the autogenerating LookML for a new project creates in a certain view this comma...
How do I stop Looker from modifying queries?!?!
Hi. I have Google BigQuery queries that run perfectly fine in the sql runner, but will not run in production b...
Concatenate strings in liquid if statement for label
I am trying to concatenate strings inside a liquid if statement as part of the label argument of a dimension b...
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...
Moving Unnest Statements to the end of the query
When we use unnest query to flatten arrays in looker, by default the joins are added in the same order of the ...
how to hide base dashboard being extended in a new model from LookML Dashboards?
I am extending an imported projects dashboard. I created a new model that references the base dashboard and th...
