Filter Suggest Performance
An explore we have available to a selection of users has a field to match a text block in the database. Curren...
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
Is there any way to restrict a user from modification on certain view files only.
Hi, Is there any way to restrict to edit certain view files to those users who has develop permission ? Basica...
Formatting Dollars in string using Table Calculation
Here’s a fun little hack — I wanted to create a written text statement that can be copy and pasted out of Look...
How to pass an exact date from dashboard and then calculate a query?
For example I was my dashboard to have data filtered before a specific data say 5th September and I want user ...
Can I calculate a dimension in one view that references a derived table from another view?
I currently have two views: View A has a list of customers and View B has a list of orders. The two views are ...
Moving dashboards to a new model
I have an issue with access filters in two explores. First, I have an explore ‘X’ that has an access filter on...
Unnecessary Re-validation on commit
I think I’ve come across a bug. When writing LookML, after saving changes and validating, when I click the ‘co...
Layer, Refinement, Extend or: what is the best solution?
Layer, Refinement, Extend or: what is the best solution? We are currently working on the largest of our LookML...
Drilling into a Measure after it has been "Dimensionalized"?
Hi all! I am wondering if there is a way to preserve a Measure’s drilldown after it has been “dimensionalized”...
How to connect Stored procedure to looker
Hi Guys, I have sql server stored procedures data as a source so how to connect stored procedures to looker pl...
Post on Improving Looker Model Governance (Contribution, Code Review, and Testing)
Hey everyone, I wrote a short blog post on how we’re trying to improve the governance of our Looker model at Q...
code folding in Looker 7.14
In Looker 7.12 and below, when developing in LookML, one could previously fold the view file code using an opt...
Filtering within a measure
I would like to know the best way to approach this business case. I currently have a view where I am displayin...
Filter a derived table based on an explore
Hi all, I have this view which I need to filter: view: orders { derived_table: { explore_source: orders_exp { ...
Bug in download options provided in Looks
Steps to reproduce; Navigate to download from here option available in the look. Select format as JSON 3.Obser...
OR Conditions in Looker - a nightmare or am I just thinking wrong
The following problem: I have a department. This department is responsible for several products. Now I have to...
Issue with "Filter On..." feature when clicking on a dimension in a table on a lookml dashboard
When we upgraded our looker version we are now seeing this feature on our lookml dashboards where someone can ...
Field Sets Extended with Explores?
I’m working on some development that is attempting to be as DRY as possible. I’ve set up a series of ‘base’ vi...
Period over Period and YTD/MTD
Hi, I’m working on a few period over period comparisons at a daily level data compared to last months data. Cu...
Fing & Replace in Project doesn't show "select" option
After the “Redisigned IDE” change from release 7.12 there is no option to select in wich projects I want the c...
Fiscal Quarter Not Picking Up Transactions on First Day of Quarter
We have a fiscal quarter offset of 1 month. So our Q2 is from 5/1 to 7/31. We are experiencing issues where tr...
Getting the minimum value
Hello. I am having some problems with getting the minimum value, and was hoping you guys could lead me in the ...
Calculating employee performance by quartiles every week
Hi Looker fam, I have the table below that shows the contribution of each of my employees since they started, ...
Avoiding inconsistencies across explores
LookML developers have many easily-discoverable tools to optimize the UI of a particular explore - group label...
create dynamic dimension from user selection
Hello, I’m trying to create a dynamic dimension that is based on user selection from other dimensions. For ins...
Bring day-by-day average data for the last 6-month
I have Date as dimension and revenue as a measure in my project. I want to have a table with one column of the...
Lookml Code "Warranty"? Anyone ever been advised that their was a warranty on Lookml?
Just off a call with Looker, and we were advised that after 7.8 broke our existing lookml model that nothing c...
Create a measure to disaply the max value from a column
Hi I have a table with the below data and I want to create a measure to display the same values as the custom ...
User Interface for DB modification via Looker
I’m not sure this is actually a LookML question but I’m not sure where else it would fit. My group is investig...
Simple Use Cases for the Extension Framework
Hello, I was looking into the documentation of the Extension Framework and I wanted to ask for your advice. In...
