Shared filters/parameters between multiple views used in one visual
Hello,we have two views on two different fact tables joined inside one explore (not the same granularity and d...
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
Fire off drillmenu:click event without redirecting to link
I noticed there was a similar question but no response so I’m asking myself.Currently we have embedded dashboa...
Set default value on lookml dashboard using another filter (and its associated parameter)
I was wondering if it was possible to create a filter based on a parameter and have the parameters value be an...
Can't edit my own Looker dashboard
I'm using Looker with my GCP account (https://lookerstudio.google.com/). I have created a dashboard, used it f...
looker date filter with timezones converting from datetime to timestamp
I have created a date filter and then want to use the start and end date to filter a derived table. filter: da...
Running Total by Category & Date
How can i calculate running total by category sorted by Date. I know there is option available by using runnin...
Calculate sum of column and repeat value across all rows.
Hello, I am trying to go from this: COL1 COL2 ABC 1 DEF 2 GHI 3 to adding a sum of Col2 to Col3, but so it dis...
Question re: "A Cure For the one_to_many Blues" Article
Hi All,I've implemented the "Join Paths" model design described in Fabio's "A Cure For the one_to_many Blues" ...
Retain Filter selection in Dashboards using temporary storage options via lookml
Hi Team ,Is there any option to save user selection on filters via look ml like a temporary storage of filter ...
When I connected the LookML project to Github, the code disappeared.
Thank you for your help.Thank you for taking a look at my question.I created a new LookML project automaticall...
How to access start and end time of the dashboard filter(of type date_time) in view file
I have one field of type timestamp in the database and have created a filter in the dashboard on that field.Wh...
Visualization for two datasets
Relatively new to Looker, my IT team has created views of datasets which I am then able to visualize on dashbo...
Rolling sum from the same column
Hi All,I have one column A in my table A, the value saved are the sum of different series and I want to create...
Filter with multiple columns
I have 3 columns which should come in a single filter dropdown . But the condition is such that if it is enabl...
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...
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...
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 ...
| User | Likes Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
