FIiter an explore before join
Hello, so I have two problems.PROBLEM1So, I have this explore and join in a model. I want to join some values ...
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
Split aggregation for a filter in LookML
Is it possble to use something similiar to string_split in LookML to get unique value for my filters?I have a ...
Filter Period-over-Period Analysis based on customer cohorts
Hey Guys, I build a PoP-Analysis for an orders dataset. I want to add the following logic now: If I am choosin...
Creating a measure for same day last month
Hi folks, I’m looking to build a measure to sum a number e.g. outstanding balance for the same day last month....
Quick Starts: Limit of 10 per explore?
I’ve been adding quick starts to an explore using the query objects. It appears the UI doesn’t support adding ...
Using user attributes with week start day
I have two clients working in explores on the same model who need two different settings for week_start_day. D...
What max cache can we set in Mbs/Tbs ?
Hi everyone,Whos know max cache in looker which I can apply? Because I found only default value (2000mbs.) --o...
Looker Filter Expressions
Hi Community!What are the differences between measures leveraging Looker Filter Expressions and When Case Stat...
Explore Doesn't Show up When Creating a Project, and I can't create an Explore in the Model File
This should be basic, but I can’t figure out what’s going wrong. When I create the project from a single table...
Case Statement
New to Looker and need some help. I have the following query which works fine. What I’m trying to do is add a ...
How to set a relative date as the default date for a date filter parameter?
How to set default value for a date filter parameter which is like ‘3 months before todays date’ and also give...
Conditionally multiplying a numeric filter
We have an implementation of Period-over-Period analysis that we’ve paired with a date granularity filter so t...
How Join with two explores?
HiI built one explore :I want built customers explore and add these tables with left join to the explore but I...
can you hyperlink from within a field description?
Anyone have any hacks for including a hyperlink in a field's description? The use case is that sometimes we wa...
Quickstart visualization formatting
Is there a way to apply some default visualization formatting in a Quick start? For example, I want to turn of...
Format both positive and negative numbers in billions, millions, thousands and less than thousand
Hi guys, How do I format both positive and negative numbers in lookml. I want positive and negative numbers to...
Datagroups and caching with dynamic schema value
Hi everyone! I have a somewhat open ended question that I can’t seem to find any information on… We have a Loo...
join an explore with all its existing joins
Hi! I want to join explore A to explore B in my data model in lookml. Explore A was defined earlier in the mod...
How to create calculated field between two measures in different views?
So, I have two different views, that both have measures “count user ids”, but based on different events: i.e. ...
Looking for Duplicate measures
I have been looking at the LookML code searching for duplicate measures. As of now, I am manually copying the ...
Calculations with date filters
Hello, I am trying to calculate the difference between two amounts over two date ranges. I created filtered di...
Can I do a calculation across multiple tables measures?
Hello Looker Community! I have a task to calculate a total measures across different tables.Im trying to do a ...
Filtering with lookup tables
I’ve got a user who want’s to be able to input a child product id and see the list of that products parent as ...
Style options for dimensions of type: tier
See the documentation about tier styles in our docs. As of Looker 3.14 we has added several style options to t...
Avoid TO_DATE casting when data type already is DATE
This is the LookML dimension_group: dt { type: time timeframes: [ date, month, quarter, year ] convert_tz: no ...
For Loop in Looker
Hi, I want to use for loop in LookML file to do like something below:I don’t want to write 1, 2, 3 for each sa...
GA Runtime Case When Error
Hello! I’m currently having some trouble when switching to the new GA Runtime. Line of code in question (runs ...
Testing A Materialized View in Looker
I just created a Materialized View (MV) in my Looker development instance and I can see the MV in SQL Runner. ...
Row Level Security with Explores & SQL "Injected" Dimensions
We currently use user attributes to filter out other clients information in our Looker dashboards. Originally,...
Sharing Looker Dashboard among users
How can we share the same data pool but different visualization on the same dashboard for different users?
