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...
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
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...
How do I bring a map of Brazil
How do I bring a map of Brazil, I tried to put the map_layer property: statesBr{ file: "/maps/brStates.json"}B...
Create a measure which calculates percentage difference between two dimensions
Is there a way through LookML to workout the percentage difference between two numeric dimensions? Such that I...
Rollup VS Grouping Sets
hi everyone,I have a table that shows the amounts per customer.These customers belong to categories of custome...
Looker Wrapping Parentheses around Dimension Causing Incorrect Syntax
I have the following LookML code(select max(${origin_event_date}) from ${origin_table_name}))It should be gene...
How do I fix the error "select list expression [...] references which is neither grouped nor aggregated" in LookML?
I get the error "invalidQuery: SELECT list expression references tb_ind_performance_360.mes which is neither g...
Filtering on a specific datetime
Hello!I’m trying to create an Explore to allow investigations on the data below.In the table below, delivery_d...
