File names truncated
What’s with all this text truncation all of the sudden? There is no label on hover either and sometimes it’s 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
Liquid Boolean "not" Operator
Hi. I’m trying to use the Boolean “not” operator in Liquid. It’s not working as expected, and is documented as...
Integrating learn.looker.com with lookml
Hi, I have learn.looker.com instance and I would like to update the looker objects (Models/Views) using lookml...
Brainstorm: Reusing common views
I’ve been thinking about ways to simplify logical model of LookML and one of the main issues that come to mind...
Combine "FULL OUTER JOIN ON FALSE" with "Introducing bind_all_filters"
Hi. I read the article " Outer Join on False - or: How I learned to stop fanning-out and love the NULL and [An...
Dashboard panels show errors until reload
I’m seeing a transient error on some of the panels of our dashboard. Reloading the dashboard often clears the ...
How to get CURRENT_TIMESTAMP for MS SQL Azure
I’m looking to extract a simple CURRENT_TIMESTAMP as a field in my LookML. For a MS SQL Azure DB. However, I k...
how to do or improve a "hard coded forecast"
I am looking for opinions on how to do or improve a “hard coded forecast” (I dont really know what to call thi...
Invalid queries generated when using CTEs in Spark
Hi Looker community! I am having a very frustrating experience with CTEs and Spark 2.0: We’re currently migrat...
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...
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...
