Table Calculations without row limit
Hello,I have a sales table by seller. I want to calculate percent of sold quantity by each seller. But when i ...
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
What exactly is a scratch schema?
I saw this term “scratch schema” when learning about PDTs. I guess it would mean database schema design or som...
How to display only a single column for a measure within the pivotted table?
Hi!I’ve been working on a looker explore (using LookML of course!), and I’m attempting to display only one ins...
Dependent Looker filter depending on user selection in dashboard filter
There is a dashboard filter with 4 user input selections. Based on what user selects there I want to be able t...
Show related table field as field and list second related table fields as list
Our data models look a bit like this:user: { id, email, name}segment_type: {id, name}segment: {id, segment_typ...
Dimension Custom Sort
Is there any way to custom sort the Dimension in not alphabetical order besides of adding extra spaces in the ...
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...
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 ...
