Braze Integration Action
I have enabled the Braze Action in Looker to be able send customer data to Braze. I would appreciate if you co...
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
Quick Start Queries in a separate file do not show up in Explore
After three tries with Support, I’m hoping that somebody here will be able to help me with this. I’m sure I’ve...
Filter data on max datetime for each id’s
Hi ,I have a requirement where is need to filter data on max date for each id’smy data looks thisid datetime a...
LookML error "Can't construct persistent derived table"
I created datagroup and persistent derived table as below. but it keeps giving me an error. model```connection...
Does cross filtering override /disable Drill fields?
I have defined drill fields for a measure but they do not show on the tile when clicked on the measure from th...
Count repeated values in a column
Hello!I wanna know if it is possible to calculate the number of occurrences of a repeated value in a column. F...
Add a join to a preexisting view
I have a preexisting View, originated from a table in the datawarehouse, and I would like to add to this view ...
problem with regular expression in parameters started from '^'
parameterr: reg_exp { type: string default_value: "^(Act|(.*_Act))[A-Z]{1}[^_]*$" } derived_table: { create_pr...
Create matrix using a dimension containing the names of several measures and display their values conditionally row by row into a dummy measure
I am trying to create a table in which I display the measures names in rows while bringing their respective va...
Drill fields on measures using filters
Hello!I have question related to drill fields on a measure. From my understanding, drill fields will utilize t...
What are "best-practices" for organizing location/geographic data so that it plays nice with map layers?
Hello! I’m experimenting with map layers for rendering data in geographical regions and I’m finding some limit...
Derived table with SQL that references other view dimensions?
I am trying to create a new view which is derived from existing tables/views that are already specified in Loo...
select field list and make new query with this list
I would like to select field names from one table and pass their list to another select.I know how to do this ...
NOT IN of SQL in LOOKER
Hello everyone, I would like to know if I can use SQL NOT IN in Looker in a dimension.Example: sql: ${TABLE}.I...
Liquid checks in persistent derived tables: Triggered builds failed?
Hi,My PDTs work fine unless the build is triggered by Looker instead of through an Explore.I have the followin...
Use dimension when creating measure with Case
I am trying to create a measure conditionally based on a dimension.column is a dimension while geo_area.count_...
Populate earliest date of status at item level in each row
Hi Guys,I am a beginner in Looker and trying to achieve below requirement.Data set : Item_id created_date stat...
Model calls to another model causing duplication
Model calls to another model causing duplication.We have fixed data model across our customer which is model_a...
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...
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...
