Is it possible to rename fields when joining a view to a explore?
I would want to rename a field when doing the join of a view into a explore, to have a more descriptive name f...
Forum Posts
Fill missing dates before join
Hello,To provide some context, I’m looking to make an “ARPPU Cohort”, which looks like something like this ;Ba...
How to query a view from a eplore withouth joining it
Hi,I’m trying to solve a problem with a model, to adapt it to my necessities.I have an explore joined:explore:...
join based on multiple conditions
I am trying to join 2 tables in the explore using sql_on.The first condition is ON and the second condition, I...
Inaccessible view error when joining a view with a "from" parameter
The problem is that I have a measure that is defined in a refined view that then is joined into an explore. Th...
Error: Dimension containing a link joined into a explore causing blank screen when used
When I try to bring a dimension into a Look my page just goes blank. I have isolated the cause but am unsure o...
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 best design for unique users count
Hi, Trying my luck with a new topic as I have not found anything yet. We have daily aggregated data with certa...
Primary key doesn't seem to be recognised
Has anyone dealt with this error before?I understand what it’s saying, but I have primary_key: yes defined in ...
LookML model join is using fields as numeric when they are both defiled as string
Hi All I am getting the following error in a LookML model on a join - it seems to be trying to join post codes...
Moving Unnest Statements to the end of the query
When we use unnest query to flatten arrays in looker, by default the joins are added in the same order of the ...
Change join type dynamically with filters or parameters?
Hello everyone, I have a bit of a particular situation and was hoping for a workaround. Our Purchase table is ...
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...
Dimension using other view that is joined many times
I have got a database with a very strange order architecture in which any order might have a parent. Sometimes...
Left Outer Join Help
I have put together what seems to be a fairly simple left outer join query but it is acting like a full query....
How To: Smart Partition Key Filtering with Liquid
Problem: We have multiple partitioned tables, and are joining them into an explore. To improve query performan...