Dimension Custom Sort
Is there any way to custom sort the Dimension in not alphabetical order besides of adding extra spaces in the ...
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
Problem in implementing Period over Period Analysis
Hello,I try to follow the metholodgy explained here to compare 2 “time” to hire from differents periods of tim...
Unsupported operator: OFFSET
Hello,I try to calculate the variation of a metric that change everyday, I would like to display the percentag...
JSON from Google Sheet as Data Source
I have a Google Sheet that’s filled from an API that I’m using as a Looker Studio Data Source. The problem is ...
How to get filter selected minimum date and max date, and display on a table
I have a table with multiple columns, one of which is "Created_date". We also have a filter applied on "Create...
Create a Tableau connector for Looker
Hello, I need use a Tableau dashboard with a data source for Looker Studio. How can i create a connector for t...
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...
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...
