How to utilize the value of a dashboard filter
I am building a dashboard where I want to compare numbers for one store versus the rest of the stores.I’ve see...
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
Subtotal not displaying correctly
Using an Apache Spark 3+ connection, I am trying to display simple subtotal results. Instead, the results are ...
Liquid HTML
I need help in creating a lookml dimension or measure to show the value for a YES or NO in map. I created a di...
Use dimension when creating measure with Case statement
I am trying to create a measure conditionally based on a dimension.My dimensions:dimension_group: date { hidde...
Comment out a block of code for AZERTY keyboard (or any non-English keyboard layout)
A lot of customers of Looker that use non-English keyboards (such as AZERTY) are unable to use keyboard shortc...
How to calculate multiple column values based on condition through measure
i have 4 column(ai_ov_s008,ai_ov_s009,ai_ov_s010,ai_ov_s011) but i need to add condition based on condition we...
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...
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...
