Calculating average across two views in looker when dealing with timestamp difference
I am working with a data where I need to calculate the difference and average of when a user is created and co...
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 Incremental PDT creates and duplicate records
Hi, Recently I have implemented incremental PDT and after few weeks I realize its creating duplicate records i...
Filter Data To Only Show Values That Appear Once
Hi, I have data where “order numbers” can be repeated for multiple rows. I am trying to filter so that only ro...
Remove (past) always_filters in looks and tiles
Is there a way that I can automatically, or at least done at once, remove filters that have been once set as a...
How can I hide the demo Explore?
I want to hide both “eCommerce” and “System Activity”, so when I click on Explore it only shows me “Vendas”. H...
Looker Claim Broken - 'Problems with the connection' error
Hi there, Without any changes being done, I suddenly came across broken reports on my Looker this morning. Kin...
Find range (or Max value minus Min value) for each unique building
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Data source migration
Best practices around migration for looker from redshift sql to databricks sql.
Repointing Data source
How can we repoint data source from redshift to databricks in looker?
Find range (Max value minus Min value) for each unique building
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Unknown Error Just Started Today on Daily/weekly scheduled reports
This error is being thrown with schedules. It only began today and no changes have been made to the schedule o...
How Can I download all the dashboard folder name, Dashboard name and Dashboard URL within the project
Hi,I wanted to import all the dashboard names and dashboard folder name and Dashboard URL into a spreadsheet. ...
Issues displaying long comments in table
Hi all, I have a table inside a dashboard that shows 5 columns including one for comments. I am having a issue...
pull remote changes from prod branch
Hi, i have made some changes on the master branch without using looker ide. Now looker has not been updated wi...
Combine Multiple dimensions into single filter
Hi, I’m pretty new to Looker. I have a dataset with multiple dimensions my client wants to filter on (too many...
Data source loads, but can't visualize
The following code ran in Looker and created a data source without issue. But when I went to create a report, ...
Group label not working for measures
Hey! Hope you are doing well! I’ve notice that all group_label applied to the measures we have are not working...
Coalesce two date columns into one
Hi there!I have two views that I’m joining in an explore. Each view has a `created_at` column that I would lik...
Display LookML dashboard in extension framework
I’m attempting to create an extension framework application for a lookml dashboard.How can I use the looker co...
How to concat and convert date from from YYY-DD-MM to MM/DD/YYYY
I want to write a dimension with adding text values and date with MM/DD/YYYY formateg: Result for: 2022/11/05 ...
How to change the date format from YYYY-MM-DD to MM/DD/YYYY and add text before date
I want to write a dimension with adding text values and date with MM/DD/YYYY formateg: Result for: 2022/11/05 ...
Need to create a field that returns a Yes/No based on timeframe chosen by user
I have a table of Tasks with the description/info of the task as well as that date it was created.What I need ...
Extend view and use its dimension in a derived table sql
Can I extend a view and use one of its dimensions in derived table sql query?Here is an example of what I am t...
Moving Averages as Measures
I’ve come up with a “hacky” solution to including Moving Average as Measures into existing Looker models descr...
How to query a view from a eplore withouth joining it
Hi,I’m trying to solve a problem with a model, to adapt it to my necessities.I have an explore joined:explore:...
How we give the customer our Looker Project so they can deploy it.
Hi Team,I Created a Dashboard In the Looker, for these same dashboard i have to deploy to different customer’s...
How to restrict user from selecting an end date which is more than 1 year from the start date?
Start date and end date are parameter of type date. I want to add a logic which will restrict user from select...
Update(write-back) data on BigQuery from Looks?
Is there a way to let users update data on DB right from looks? I read about actions here but I found it very ...
how to make text box dynamic
I have a dimension product_name, and my requirement is that in dashboard I want to show user with the text: “H...
connection issue
Cannot connect: time zone tables don't appear to be loaded JDBC string: jdbc:mysql://14.97.218.174:2300/uc_dat...
