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...
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
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...
does deploy to production apply to all the lookML projects
When pressing the button of deploy to production in the specific project in looker, will it also merge my pers...
HTML Class Library
Do looker have any doc or library for visualization class like:class =”vis”class =”vis-single-value”Where we c...
How to remove transparency in Looker filter?
Currently in our Looker instance we have a grey background setup. However, when a Looker Filter is not selecte...
aggregate data download log
Hello,I wonder if there are any ways to check the users who download the files from the lookml/user-defined da...
Dimension does not execute in explore
I have:dimension: fl { type: string sql: CONCAT('flt-', ${departure_date}, '_' , ${oa.iata}, '-', ${da.iata}) ...
Customizable drop downs using the HTML details tag
Using the HTML syntax it is possible to create drop down buttons that can display additional information relat...
Create a custom filter that defaults to current week Sunday to Saturday
Hi Looker geniuses,Is there a way I can create a custom filter that defaults to the most current week from Sun...
Warping the render value in Single Value Vis. via lookml html
I'm trying to make a tile in dashboard were value will be rendered through Look ML html via a single value vis...
Passing Dashboard filter as a parameter
As the title suggests I need to pass a dashboard filter as a parameter instead of a filter for a look. Is this...
Access Grants
I have user attribute department defined in my looker instance.I have added this code to a model:access_grant:...
Feature request - SQL WHERE but only if joined
Sometimes I have two simple views connected to each other but since it’s LEFT_OUTER, there may be some entity ...
