How to reference the latest PDT's in an SQL query?
So we have PDT’s that are refreshing quite often in the company I work at. In addition to this, we need to que...
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
Cannot create a derived table using SQL
Hi, I’m new to Looker, and I’m trying to do the following: Take a lengthy SQL query that I built and save it a...
How do have wk. 52 show as 2021 and not 2022?
We have a dimension_group that extracts timeframes from a timestamp field. We want to compare year over year f...
[Analytic Block] Affinity Analysis
See the code for the block Other applications: Segmenting products in a 2x2 matrix (top performers, opportunit...
Could not find constant
Usually it happens to me after a deployment. The model file is opened and I see the error “Could not find the ...
Filter on a dimension and use the result to filter another report
Hello I have to create a report where I need to find all the items in a transaction other than the filtered it...
Why my sql query is taking so much time
I’ve made a SQL query for one of my project but it’s taking so much time. I got it refreshed multiple times bu...
editing lookml dashboard
Hi I am having an issue with editing a lookml dashboard that my org created. I can access and edit the file in...
Is there any way we can say which dashboard an SQL query belonged to?
We have Looker on top of Snowflake, but we would also like to monitor the queries executed by Looker in Snowfl...
Select all Filter option
Does anyone know how I can achieve this? I’m trying to set up a SELECT ALL filter like the below on looker. Ca...
Removing Single Quotes from a String with Liquid
Working with strings using Liquid can be a very powerful tool within Looker, but it also can add another compl...
Look ML Developer Exam
Hi, I am planning to give LookML Developer exam and was wondering how many questions are there in the exam? Is...
Context Comments
Please see this documentation page for comprehensive information. A labs feature to add a SQL comment to the b...
What is the looker recommended folder structure for LookML development ?
With different type of files (objects) like models, views , refinements, explores, datagroups , what is the lo...
Can tables within the same schema become a filter?
There are many tables in our database having the same structure, and all of them need to add some customized m...
Add Multiple URL's in Looker (Or Alternatives)
Hello Community,I am trying to map_layer parameter to add custom EU (DACH) map. I am not able to find TopoJson...
Filter replicate sentence where field1 in (select field2 from table2)
I have a big problem with Looker, I need to do a filter in Tile or LookML seems like sql query sentence. It’s ...
[Analytic Block] Simple Funnel
About This Block A simple funnel is a great way to look at events or transactions. Starting with just a few ev...
Applying HTLM to table totals
Hey Looker Devs!Is it possible to have the HTML conditional formatting apply to the totals that are shown in a...
DATE_TRUNC timestamp to week in SQL Runner
Hello, I’m using SQL Runner for the first time and am attempting to roll up a series of dates into their respe...
How to create table calculation for measure or field group by one dimension
Hi team,I have three columns ColumnA, ColumnB and Measure in Explore. I want to aggregate sum(Measure ) group ...
HTML rendering in new dashboards
Has anyone else had issues with HTML rendering differently in the new dashboard experience? The spacing looks ...
Accessing Looker Data Dictionary through Looker API
Hi All, I would like to move all the information found in the Looker Data Dictionary of my project into a csv ...
Using a field from a different view
Hello All,I have a view called patient, and a view called risk. Risk has a foreign key patientId to patient, a...
The filter "Xxxx" is not allowed when using liquid parameter in dynamic derived tables
Hello,I have a problem, I am trying to dynamically query column from the database, I wish to create a paramete...
BQML blocksを使ってLookerでBQMLしましょう
※ 本投稿はLooker Advent Caledar 2021 22日目の記事です。年末にお小遣い稼ぎをしようと、株を買ってみようとしたんですが、せっかくなのでLookerでBQMLを使って予測した結果を元に売り買いし...
Learning videos
Hi, is there any way to access videos separately (as it used to be), without the learning modules combined for...
Filter Error Handling
Is there a way to seamlessly handle when a user enters the wrong information into a filter? IE: They put. text...
Fixed Calculations and Other Level of Detail Functions
Hello fellow Lookers,I am relatively new to using LookML and I am coming from a long time working with Tableau...
Downloading Visualizations in Excel
After creating a Dashboard, I tried to download one of my visualizations(Line Chart) in Excel format but it do...
