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
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...
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...
