Setting up Looker Links to Dashboards and Explores through Liquid Automation
What is DrillingWhen you’re exploring data, I like to think of drills as being either having horizontal qualit...
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 do I change a model/explore for a Dashboard
Hey all,I have built a dashboard under project A ( model name: A) and now we have a new project B with a new m...
LLM integration (Gemini) with Looker
I want integrate the gemini with looker. I want to build dashboard with gemini intergration if we ask some to ...
Data trigger runs on 1st day of month instead of last day of month
Good Day Looker Community Hoping to get some assistance with the below trigger that I have created.Goal: Looke...
Dimension Groups / Hierarchies for Strings. Like Product Hierarchy, Or Region Hierarchy
How can one implement below in looker?Let's say we have a sales report, and content is sliced and diced via co...
Best practises for Total metrics in datasets
Hi, i am just wondering what is your opinion about including TOTAL metrics in a dataset.I have a dataset that ...
dynamic hyperlink
Hi, is it possible to create a dynamic hyperlink that opens a new report and updates two different data sourc...
Inaccessible view user_mini-session referenced in retention
Hi, I am having some issues referencing a dimension from one view into another. (unable to post without the sp...
Having different hidden states for the same dimension in different explores
Hi there,I am trying to 'hide' (hidden: yes) a dimension in one explore, but have it visible in another.I am a...
Show custom message for empty resultset
When there is empty resultset for the looks in the dashboard, how to show a custom message instead of "No resu...
Liquid variable
Can i use this logic in a liquid variable in an explore?{% if table1name.dimension._in_query and table2.dimens...
Connecting Looker to SAS
Does anyone know if you can connect Looke r directly to a SAS table/server? or would you use a work-around to ...
Alternative to a Right Join in LookML
I am tying to create a viz that displays inventory and sales data per sku for all of our products. As a simple...
Dynamic date range filters in PostgreSQL
Hello everyone!We are implementing Looker with a warehouse in PostgreSQL, we have some Facts partitioned by da...
Full Outer Join Primary Key Issue
Hi,I would appreciate any help related to the following situation. I have 3 views:Users - Unique table of user...
sql_query SDK Encoding Error error.SDKError(response.value.decode(encoding=encoding))
When calling sql_query method, I receive an SDKError for encoding with the below stack traceSDKError Traceback...
Testing LookML and Looks
I love that Looker has the ability to perform #testing on the data within the #lookML. Great details documente...
Arrays from clickhouse to Looker
Hi there,I understand that array types stored in clickhouse can not be retrieved in Looker unless converted to...
Automatically create Lookml Views, Model, Explores
Hi, I was wondering if it is possible to create Look-ml views, model, explores automatically. Somethin like wh...
Incremental PDT creates duplicate records
I have an incremental PDT set up with a pipeline_run_date (truncated to the day) variable used as the incremen...
Building a Flexible LookML Model
Hi everyone,I'm seeking guidance on creating a LookML model that empowers end users to construct dashboards wi...
Linking filter values across custom measures
i have several custom measures on a look where for each measure i filter on a different field having the same ...
Dynamic number of occurrences of weekday calculation
Hi,I have a bunch of call centre data that I'm working with. One of the things I want to do it be able to calc...
Passing user input date to where clause filter to the resultset
Dear all,I would like to get your thoughts on the below scenario.I have a table with a reporting date as a col...
Dynamic Parameter for Dashboard Tile?
I am trying to build a tile for a dashboard that inherits a region dimension from the filter.Basically, the ti...
Open dimension URL in a popup window
I would like to be able to render html inside a popup windowHere is my dimension:dimension: view_HTML { sql: '...
Link not passing dashboard filter value
I’m trying generate a list of dashboard names that link to the referenced dashboard. In order to accomplish th...
liquid condition / endcondition / _is_filtered when using AND/OR filters
Until the Feb 2024 release of Looker, it was possible to use the liquid {% condition dimension_name %} dimensi...
Dynamically apply calculation to all table values
Hi everyone!Little stuck on on something…Image that there is a table with one dimension with a bunch of measur...
Filter Max Date by different timeframes
Hi! I have an unusual use case that i would like to resolve. I have a BigQuery table that has information week...
