How to query a view from a eplore withouth joining it
Hi,I’m trying to solve a problem with a model, to adapt it to my necessities.I have an explore joined:explore:...
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
How we give the customer our Looker Project so they can deploy it.
Hi Team,I Created a Dashboard In the Looker, for these same dashboard i have to deploy to different customer’s...
How to restrict user from selecting an end date which is more than 1 year from the start date?
Start date and end date are parameter of type date. I want to add a logic which will restrict user from select...
Update(write-back) data on BigQuery from Looks?
Is there a way to let users update data on DB right from looks? I read about actions here but I found it very ...
how to make text box dynamic
I have a dimension product_name, and my requirement is that in dashboard I want to show user with the text: “H...
connection issue
Cannot connect: time zone tables don't appear to be loaded JDBC string: jdbc:mysql://14.97.218.174:2300/uc_dat...
Date Range Control compatibility with AWS Redshift: to_timestamp(numeric) does not exist
There’s likely a compatibility issue on `to_timestamp()` with AWS Redshift and the following is the error that...
Dropdown null issue
We are using three different data sources in blend Data sources(Cloud SQL for MySQ, Google Sheets and BigQuery...
Looker explore issues in custom filter
Hi All,In custom filter, I want to give the measure to take YTD data along with some specific id.My YTD condit...
Date Parameter in Derived Table used in more than one way
Has anyone been able to efficiently parameterize a derived table with a date parameter such that the date is u...
Looker bug in Aragonite parser with Liquid and filters
Hi, anyone experiencing this bug?Full project to reproduce it:https://github.com/vlorente1/aragonite_templated...
How to use Or condition in dashboard filter?
How to provide Or condition between 2 dashboard filter. ------in order to resolved this I tried user custom fi...
cannot override constant from remote dependency
The topic at https://docs.looker.com/reference/manifest-params/remote_dependency#overriding_imported_constants...
How do I sum values that start as strings and have decimal points
Hello!I have a BQ table that contains values like 10.0055858585 and 0.069872323 in a column that is a STRING t...
Introducing the Style Validator, a new LookML linter!
Ever since the dawn of time (or I guess ever since we launched Spectacles), our customers have been asking for...
Creating schedules return not helpful error message: Uh oh! Something went wrong.
In trying to create many schedules (20 so far) from a Look, it is often that I get the ‘Uh oh! Something went ...
Partition pruning from looker filters based on labels
Hi,we have bigquery table as source for our view/explore.This table has (to simplify) columns:REGION_NAME, REG...
[Analytic Block] Flexible Period-over-Period Analysis
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
Query Failure with undefined method 'gsub' for nil:NilClass
I am getting this error message on an explore when trying to pivot across a date type. This is the error I am ...
Query execution failed: - Function not found: TRUNCATE
I am trying to execute the Dynamic tiers from the documentation.https://cloud.google.com/looker/docs/best-prac...
How do you handle this string 2023-01-06T00:00:00.000Z when casting as timestamp
Hello!I’ve been working in Looker trying for at least an hour to try to cast this string format (in a table co...
count does not count distinct primary key
Hi,from looker documentation "type: count measures do not support the sql parameter, as a type: count measure ...
Difference between Save and Commit
I believe hitting the Commit button commits your code to your personal branch.But you go around hitting the Sa...
Having a linkout per model/connection
I have a Looker project that consists of multiple models and connections. I want to have a linkout to another ...
count lookml with user input filter
hi, i have created a measure with count and i have 2 questions:on which granularity is the count performed? i ...
how to count through explore page
Hi,When creating a measure in lookml, i can set the type to "count”however in the explore page i can only do c...
Dynamic Measure Not Working
I’m trying to create a report where users can view the Revenue by month OR the Clicks by month. I think Dynami...
Dynamic Drilldowns via Corresponding Dimension
Is there a way to dynamically change the drill field set attached to a simple count measure based on the dimen...
Deep hierarchy in LookML
Hi guys! I have a question if I have two tables one with the information of every id and one that determines t...
Point to one or another table based on date filter
Hi!I have two tables on BQ, one table has the historical information (= 2022).I’m trying to create a Liquid se...
