Is it possible to create a derived table from two different models?
Is it possible to create a derived table/ join two views from two different models(with two different connecti...
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
Add Date Field in Drill Field
I have an END Date Field in my View that I want to include into a measure drill field. The End date is defined...
Data Lineage for derived table
Hi! I'd like to visually check the connection structure of the derived table(and also Persistent derived tabl...
Customize PDT table name
Hi ! I want to customize pdt tables name (which will create, and store in database like bigquery)By checking ...
find the max NPS partitioned by property
I am currently working on a project where I calculate the NPS for different properties using Looker. I have be...
Multiple tables with one dataconnection - MYSQL
I’m new to Looker Studio and working with data from MySQL. I have created a connection to my database and got ...
Look showing values only when the filter has a value
Here I share something that could be useful for some customers. Usually, when we apply a filter without values...
Filter to Drill down for different tables
We have 1 main table having 3 sub tables having detailed information of candidate and having different fields....
Derived table shows conversion error
Does anyone faced an issue when you create a derived table and get the following error: #X# Conversion failed:...
Is extends really code reuse
I quite often find that I don’t want to ‘extend’ an existing explore, rather I want to ‘use’ an existing explo...
Is a combo line and column (bar) chart possible?
I didn't see this in any documentation like the example article below, but is it possible through a more manua...
How to share only a explore with an external user
Hi,I would like to know how can you give access to a user only to a specific explore.You can create a model se...
Using dimension from another view
How can I use a dimension from another view? If any links can help me. As an example, I have a view of the ord...
Is it Possible to Order the Views that are JOINed in an Explore?
Given the following Explore: explore: foobar { join: foo { ... } join: bar { ... } } When users navigate to th...
Hiding fields from a view in different explores
Hi I was merrily using fields: or fields: [] in the joined view of an explore, when I wanted a restricted set ...
Is it possible to create a filter that let you choose different dashboard versions?
Hey! My goal is to create a filter in a Lookml Dashboard that allows the user to switch between Version 1 and ...
How to give different name for one dimension
Hi, What are various way to give different names for one dimension.Dimension X have a label "nameA" I want nam...
Displaying both entries of a duplicate ID
I'm able to display duplicate values by adding a count measure that's tied to my field hash id. I then added a...
Using the BQ Info Schema Block
The BigQuery Information Schema block has, broadly, two main uses: monitoring and optimization. This article w...
Index weighting calculation
I am trying to perform an index weighting calculation, using the formula (Value in Cell * Grand Total of Grand...
Circular dependency from derived table error
I am getting the follow error: "Circular dependency detected from derived table to source explore"I have my ma...
From Sample to Real - 5 Steps for Your First LookML Project
This article will guide users who are new to Looker to accelerate their first LookML project by building from ...
Dynamic Time Granularity - opinions
I am very curious about people’s opinions on this topic: Looker Help Center Dynamic Timeframes for Dimension G...
Change design and add text to Run / Load button on dashboards
When you open a Looker dashboard for first time and start selecting some filters to update the dashboard with,...
filter dimension by an another dimension
Hi all,How to resolve this use case.I have two dimensions Y et Y and I want to create a new dimension Z who di...
Change Query by free typing in dashboard
Hi all,I want to change query by typing in dashboard level. Like There's some filter window in dashboard.And l...
bug - edit readme shows recent file instead of readme
seq:- open any file in looker but readme.md (say abc.view.lookml) - file will appear- open readme.md - file wi...
Number of arguments does not match for aggregate function COUNT
I am creating a LookML dashboard which requires some measures that are calculating a COUNT_DISTINCT on two fie...
View Usage
Hello!I wonder if there is any way to check if a view is being used and where it is being used. I'm rebuilding...
Primary key required in each View refinement?
I’ve noticed that Looker complains that my refinement views do not contain a primary_key dimension, despite th...
