How to select columns dynamically in a filter
I have a existing report which needs to migrate into looker in which one filter values are having the column n...
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
Looker Integration with Cosmos possible ??
We need to connect to Microsoft provided Cosmos DB with mongoDB API client. It looks like Looker doesn’t have ...
liquid式の参照できるviewの範囲
使用しているSQLデータベースはBigQueryです。liquid式で {% view.field_name._is_selected %}を使用していますが、こちらの参照できる範囲はjoinが定義された同じExplor...
Add special character in dimension name
I need to add special character in the dimension: #_OF_IQ_SESSIONS { } but i am getting bellow error : “ Inval...
Syntax error
CREATE TABLE STAFF(STAFF_ID VARCHAR(20)STAFF_TYPE VARCHAR(30)SCHOOL_ID VARCHAR(20)FIRST NAME VARCHAR(100) NOT ...
Difference between rows for A/B test
I am trying to build a dashboard to assess performance of A/B test (test vs control group) for campaigns. This...
How do I average a daily count over week or month in looker where I need to join the data with other tables
I am new to Looker.I have a table with a count of distinct values grouped by day.I’ve imported into Looker as ...
"Must provide a field name for parameter" error message
Hi, I’m trying to create a simple parameter to choose between 2 dimensions to breakdown a view. I’ve copied th...
How to map UK postcodes
Hi,I’ve pulled through UK postcodes of the data type character varying and in the format ‘LE184NG’Upon adding ...
How to create Native Derived Table with brand wise Rank() over order by Sum of Sale price.
Here I want to create rank column with help of Sum(sales) aggregation value in the same query. select brand, S...
Hide Fields in Explore if All Values are null
Hi Looker Community,Is there any way to dynamically hide dimension or measure in Explore if the values in that...
Is there a limitation on number of Model in looker
We have an use case where we want to create a model which contains user defined attribute for each customer. S...
How to create logical filter by grouping them into Regions
Hello,I am new to looker and stumbled upon a Filter requirement. I have a field ‘Platform Name’ which has attr...
Loading historical data using incremental PDT
I have an incremental PDT that loads data on a daily basis. However when I deploy the same to production I wan...
Setting up Looker Links to Dashboards and Explores through Liquid Automation
What is DrillingWhen you’re exploring data, I like to think of drills as being either having horizontal qualit...
Looker Platform Owner - HIRING - UK - 2500+ user Instance
Looker developers are still relatively niche, Looker developers with experience owning implementing and/or mai...
Look ML
I do not get any error while passing a date range to ‘rev_rec_date’ in SQL runner, but getting an error ‘:inva...
How to convert table string column(which is having time stamp in 1609999 format) to date format in looker
I have table which hold timestamp in number format but the data type of the table column is string.How to type...
Data connection
If I remove an existing connection to my data in Looker, will the data still be available?
Dashboard returns 0 rows / SQL code retrieves results
I apologize for the vague title.A dashboard that was created by my predecessor (no documentation) is not worki...
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...
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?
