Limitations on number type and value_format
The Looker version we are currently on is 7.18.21Are there inherent limitations when using number and/or value...
Forum Posts
Git lock error
We have a looker-hosted instance and noticed that Looker's Production Mode doesn't match the master branch of ...
Postgresql connect error
I tried to connect to a PostgreSQL database. I entered the connection information correctly and opened all the...
Group label not working for measures
Hey! Hope you are doing well! I’ve notice that all group_label applied to the measures we have are not working...
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...
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...
Complex issue with the way Looker calculates totals
Looker offers to calculate the total in addition to the details in an Explore: This has always been a bit tric...
malformed SQL for specific filter char
(i use snowflake)sequser sets filter as "contains" and puts 'test$%^23' (without quotes) then sql contains a s...
undefined method `*' for nil:NilClass
I have the following error when clicking run in explorer:undefined method `*' for nil:NilClassWhat does it mea...
subtotal error impedes schedule
query failed: Requested subtotal on field [explore.field] but it was not in the grouping fields. Subtotal igno...
Validation - errors out of date not resolving
HI, Working on a Model, and we can’t remove the “errors out off date” no matter how manner times we vaildate. ...
Is this a bug on Visualization ?
In Looker while i created a report adding Dim & Measures , the graph stack size are wrong , if you see y axis ...
LookML cannot parse Liquid
Hi Looker team,Database Dialect: BigQueryContext:We build the SQL-based derived tables.In the SQL, there are s...
GA Runtime Case When Error
Hello! I’m currently having some trouble when switching to the new GA Runtime. Line of code in question (runs ...
BUG: Invalid syntax for dimension_group when creating view from table
This has been happening for at least a few months, but when creating a view from a table, the dimension_group ...
Min/Max of a Timstamp Breaks Timezone Conversion
In our looker instance, we have a view that takes the min/max of a datetime:view: view_name { derived_table: {...
Does Looker no longer produce the `non-uniqe primary key` error when a pk is not unique?
I wanted to demonstrate how symmetric aggregates work, and how, if the designated primary keys are not, in fac...
Suck in validation loop
I click "validate LookML", get the spinning icon that looks like its validating errors, then it quickly stops ...
SQL Runner and Explore return different visualization
I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner en...
Incremental PDTs not incrementing when referencing the same derived table more than once.
I came across this problem a month ago. I have a SQL-based derived table (not a PDT), which I reference twice ...
Constants Failing to Resolve in SQL Code Generation
We started experiencing this issue recently and I wanted to reach out to the community to see if anyone else i...
value_format result is wrong
Looker Version:## Contextvalue_format definition: 201 seconds to mm:ss should be 03:21.3 * 60 + 21 = 201;But t...
Mapbox MTS visualization not displaying on Looker.
Hey there,So I am facing errors in displaying my custom clusters after successfully uploading them on mapbox v...
Primary key doesn't seem to be recognised
Has anyone dealt with this error before?I understand what it’s saying, but I have primary_key: yes defined in ...
Missing ${TABLE} prefix for some sql field of dimensions when using "Generate view from table"
Hi there,We use Bigquery and we have tables with RECORD (repeated and nullable).Sometimes for a table we have ...
the visual i create in SQL runner isn't working in Explore
I’m running a SQL query to generate a visualization but when I go to try and recreate the visualization in the...
Convert_tz ignored when filtering dimension of type DATE
I have this fairly simple dimension I use for filtering type: dateallow_fill: noconvert_tz: nobut the time zon...
Measure not working with total option.
Hi All,We have a count distinct measure and which is working fine without total option but if we check the loo...
Could not find constant
Usually it happens to me after a deployment. The model file is opened and I see the error “Could not find the ...
File content is overwritten
I didn’t miss that problem, thought that maybe it was fixed but not really:I was editing this file: /projects/...