Unable to create explore, model file doesn't recognize views exist
I created a project > Model file > Views but when I try to create an explore in the model file using one of th...
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
LookML code showing Warning in spite of copy pasting the original code after some changes
I was trying to edit LookML code to do some RND but it is showing this warning “There are some issues with thi...
Data Action where you can insert data from Look to the Salesforce.
Hi everyone,I saw on a video that you can create Data Action where you can insert data in Lookers Look cell an...
Writing dynamic SQL query in LOOKER
I currently need to write a dynamic SQL query because I need to pivot a column based on the distinct values th...
Show latest event using timestamp
I have 2 tables A & B with 1-many relationship.I created 2 views:A.view.lkml B.view.lkmlIn models, I joined th...
Can't divide on the filtered count distinct measure
Hello,I am new to Looker and I may be on a wrong track but I created a query which is made up of 3 columns: pr...
Advanced time range: search business hours only
Hello, is it possible to search in business hours only?For example 9 to 5pm Monday to Friday?
Alternate Views for Mixed Data
I apologize if someone else has asked this question but I can’t seem to find the answer I’m looking for. I’m t...
Is it possible to pull from production before comitting changes & push
The pull from production button in git actions is not shown after saving changes in dev mode. Is it possible t...
Looker Case statement
If i want to return not a string but a metric value, can that be done using case in Looker?
Dimension and measures
I am new to looker and can someone tell me the which is the right SQL while creating a measure or dimension. I...
Get the latest date of whole dataset
Hello,I have a date column and I want to get the latest date of this column. This table is updating every week...
Create a custom filter based on new options
Hi there,In tableau you can create sets from values, and then use those sets to define a new list of options f...
what if we use the wrong relationship in join lookml
https://community.looker.com/technical-tips-tricks-1021/how-does-an-incorrect-relationship-affect-queries-2368...
what happens if we use one to many relationship instead of many to many
Since many to many and one to many will both trigger symmetric aggregation, so what will happen if we use many...
How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?
I have a pre-computed metric table that has a small set of dimensions and non-aggregate measures. How do I mod...
Create custom measure that shows future expected sales
Hi, I am very new to Looker and was wondering if someone could point me in the right direction.I need to creat...
forgot to pull from production
I know that the first thing before developing is to pull from production. In Dev mode, I forgot to pull from p...
Expand Looker Dashboard Size
I have a dashboard that in the past if I created my tiles and expanded them and lined them up it would automat...
How can you dynamically hide fields from table visualization depending on customer request.
We have a scheduled legacy report for conversion to Looker that requires display of required and optional fiel...
Hiding the drill-down option
Hey all,for manually calculated percentages (for example measure a / measure b) the drill-down is not correct....
Group and Count Results by Range?
Hi, I’ve got a results set that is a table calculated list of percentages. I’d like to group them by a range a...
How to find differences week over week?
Hi! Apologies if this has been asked before - I’m having a hard time figuring out even what question to ask.I’...
Can a SQL Runner query make changes to a database?
Hi All, just new to Looker does SQL Runner access the database directly and if yes can it make changes to a ta...
Test connect: Cannot connect: connection refused: Java::OrgPostgresqlUtil::PSQLException: The connection attempt failed.
While logging in to postgres db from looker dashboard with looker as a user, i am getting the error as “Test c...
Look for query run time
HiI’m after a simple Look on the meta data to show the monthly average query run time across the whole instanc...
Create a set of custom filter options not in list of values
Hi there,In tableau you can create sets from values, and then use those sets to define a new list of options f...
filter-only-field on multiple dimensions
hello everyone, I have the need to apply a filter to a dashboard but it must be hidden, this means no user inp...
Filtered measures using SQL filter expressions
The problem starts when looker suggests that you can use sql as a filter expression inside a measure, but I ha...
Primary key
Hi,I am having trouble with joining a NDT back into the source view.I created a primary key in a refined view ...
