LookML and SQL to external database
Situation: I have a results table that shows whether a specific job has successfully run or errored. I have im...
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
Looker publish branch to remote failed
I have created a branch and developed code in Looker and now when I try to publish the branch and push changes...
Several levels of aggregation in Looker
Hi! I have a question I’ve been stuck with for a while and I am not sure how to implement it in LookML.I need ...
Run a looker provide Java example anomalies
I download the looker on making provide Java example, appeared in the operation process of abnormal
Passing column names from a query result into new query
I want to query a table that have over 2k columns and its constantly increase the number of columns. We want t...
Liquid - replacing BR tags in HTML field
I know it sounds funky but my field is an HTML field that contains as new lines. Turns out if I use html: {{va...
Sum of duration with duration-like formatting
I have a duration dimension_group between two timestamps. I would like to sum it but have the automatic durati...
Cache timing
Hi there, I have a question about cache timing.If I have a complicated derived table that takes ~20 minutes to...
Data drilling "Sorts" not working properly
Hi all,I recently found this resource by @Bryan_Weber for customizing drill down visualization.While this solv...
How a User is able to Access Looker 's dashboard in Salesforce if the he is not having Looker credentials ?
I have one report in the Looker that I want to access it in Salesforce. I have tried creating VF page but that...
Readable times from seconds
It’s often times useful to get a neatly displayed readable times. Typically this isn’t a problem, but if we wa...
Error referencing parameter of a different view
I have a view_A and a view_B which contains a derived table. I am trying to reference a 'timeframe picker' par...
Pairing filters where if you get one you always get the other
I know this is probably unlikely, but is there a way to pair two fields where if you filter by one you must fi...
Checking for string in Array
Hi,How best can I check if a string is IN an array.Lets say this is the dimension (array):dimension: tags { ty...
Setting height of the Look to fit contents in Custom Visualization
I created a Custom Visualization within a Look.I am not able to set the height of the Look so that entire cont...
Can I filter the data based on the Looker user's email address?
I want to display data about some internal user activities, but for privacy reasons I only want users to be ab...
Format List
Hi , i hope someone can help I have a field which contains a list of numbers. This is a type: string field th...
change date format
I created a derived table that count the leads that we got in each day:Instead of that, I want to count the nu...
Is it possible to combine liquid params with a regular sql query in LookML?
I have a dimension (StageName) with 10 or so possible values. There are a few different combinations in which ...
Liquid Parameters - Output inside IF block
Finally got some time to spend on Liquid and I have this use case, mostly to reduce the SQL.Right now I have t...
Bad SQL generated from Explore
BackgroundCreating and Explore with an “is in the past” 10 days filter generates the following where clauseWHE...
Is there a way to write UDF (user defined functions) in Looker query?
The context is, I want to write a function that process dates and return an eligible date
Multi-statement query in Looker
is there a way to write multi-statement queries in Looker?Like I want to `SET` a variable that can be used in ...
Default locale / Defaulting to English if no translation available
I’d like to set my Looker dashboard to essentially ignore any user locale that isn’t ‘en’.If a translation isn...
Totals don't adhere to Liquid conditions in SQL definition
The ‘totals’ calculation in the Explore view generates a separate SQL query that doesn’t take into account the...
derive max (last modified date) for each group of data
I have a table with columns--id,type,date,date last modified by,date last modified date.Situation is the date ...
why the date format changes to Mon Feb 28 00:00:00 UTC 2022
it used to be 2022/02/07 and it was easier to manage in excel. Now the defualt format is changed to Mon Feb 28...
How to allow whitespace for Liquid parameter (unquoted parameter filed)
Hi, I am trying to use "parameter_value" as an if else condition value, but “true and” is not working since it...
Aggregate strings in rows
Hello!I was hoping there was a way to build a table calculation(s) to aggregate rows into a single row. Exampl...
Convert UTC to local time zone in Looker (have bigquery database)
I am not able to convert my UTC timestamp column to a local destination timezone using a different column in m...
