Creating a Dimension based on several Measures
Hi I have three measures that I want to group into one dimension, where each measure represents one dimensiona...
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 a way to know what looks/tiles/dashboards are connected to a field (measure or dimesion)?
is there a way to know what looks, tiles and/or dashboards are connected to a specific field (measure or dimen...
need to find the first to last word in a semicolon separated string
Hi, I have a string dim that I need to find the first to last word and it’s semicolon separated. Example: List...
deleting dashboard does not delete schedule
I deleted a LookML dashboard. However, the schedule pertaining to it still exists, so I am now getting emails ...
Filter and club dimension based on the value provided by user in 'contains' filter
Hi, Is there a way to just show the value input by the user in the corresponding dimension and then generate r...
YoY Comparison for selected date Range
Hi Everyone, I have a requirement. I have a requirement where we have a date range filter in the dashboard and...
Modelling logs for improved lookup
Hello, I’m contacting you in order to get some advice on a data modelling use case I’m facing. We are analyzin...
Re-using extended explore in same explore
Hello, Our team has been working toward cleaning up our models that have become bloated and difficult to navig...
Dimension_group w/ type "time" doesn't work with datatype: datetime for BigQuery
Consider the following code: view: datetime { derived_table: { sql: SELECT CURRENT_DATETIME as dt;; # Bigquery...
How do I calculate a new key figure based on a NDT?
The following problem: In my base I calculate key figures. For performance reasons and for reasons of key figu...
[Analytic Block] Partitioned Date Filters in BigQuery
BigQuery is a scanning database, which means it scans the entire table for the columns referenced in the query...
Single filter value, multiple columns - possible?
I have 2 tables that I want to join (user, events), both partitioned on date (signup date, action date). This ...
How to execute SQL Server stored procedure from Looker
A complex query works in Looker SQL Runner but I prefer executing a stored procedure. When I entered exec stor...
looker models
Hi Guys, How to switch between multiple connections dynamically in looker models my data is not neatly coming ...
Looker Model
Hi Experts, I have multiple data sources SQL server and oracle how to switch between those data sources in loo...
need to count by datetime to a 5 second interval
So, I’m hoping someone can help with Looker/BigQuery problem. I have a user start date time and an end date ti...
Add a measure for Calculating Two Pivoted Columns and filter rows based on on the outcome (Table Calculation doesn't work; No visualization needed)
Hi all, I am kind of new to Look ML and I am facing a problem about Calculating number based on two pivoted co...
Fields cross references between views do not understand their many-ness relationships.
Cross-referenced dimensions lose track of their joined table relationships. In the following example, I want t...
Including Explore for NDT in different model without duplication in explore navigation window
I want to build an NDT which is linked to an explore existing in a different model. The problem is when I incl...
Stored procedures
Hi Guys , How to connect with looker with stored procedures apart from that PDT my source is sql server stored...
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...
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...
