send email in field-level via SendGrid
Hi everyone, I'm trying to figure out how to send email via SendGrid from Looker dimension (the way it is impl...
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
Dashboard and Look versioning
Is there any way to use version control in Dashboards and Looks with Github?I'm facing a challenge of maintain...
Problem triggering Cloud Functions with Looker Actions
Hello everyone,I spent the last two days trying to figure out how to trigger a Cloud Function from Looker.I ha...
Can I use a user_attribute for a filter title on LookML dashboard?
hello, I have a customizable dimension label based on a user attribute and I am having trouble using that valu...
Fixed Calculations and Other Level of Detail Functions
Hello fellow Lookers,I am relatively new to using LookML and I am coming from a long time working with Tableau...
Value format in looker. We are trying to break number in billiion, million and thousands dynamically
Folks,We are trying to format numbers in Looker dynamically in billions, million, and thousands dynamically. B...
Add Group Header Rows
Hello Looker Community!I was wondering if there is a way to add a group header row in looker. What I mean by t...
dynamically select dashboard time period with parameter
Hello, I want my users to use a "filter" (parameter) to select the time period of the dashboard, e.g. date, we...
How to avoid unnecessary join
Hi, I have an explore in which I join a view, say view1 to another view, say view2 like so:explore: view1{ joi...
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...
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 ...
Totals in merged queries results
Hi all, I know it's not possible to add totals to a pivoted merged queries result but I wonder if anyone has y...
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...
Dynamic value format name
I sent it to Looker support as well but I was wondering if anybody has similar requirement. I have 30+ measure...
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...
Dynamically changing looker connection inside model file
I have been trying to dynamically change the looker connection using user attributes. Here the database connec...
Arrays from clickhouse to Looker
Hi there,I understand that array types stored in clickhouse can not be retrieved in Looker unless converted to...
