Connected Sheets for Looker limitations: always_on_filters, drill_fields
Hi, I am trying out Connected Sheets for Looker, so accessing LookML explore via Google Sheets and I am seeing...
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
Dimension Groups / Hierarchies for Strings. Like Product Hierarchy, Or Region Hierarchy
How can one implement below in looker?Let's say we have a sales report, and content is sliced and diced via co...
Aggregate Awareness with Templated Filters or Parameters
I'm looking to leverage Aggregate Awareness for our large tables. Our BigQuery database is partitioned by date...
Dynamically call constant
Hey guys, does anyone know if it is possible to dynamically call a constant based on one parameter the user se...
Looker Table Calculation to get rendered value of a column
Hello Team,I'm seeking guidance on a specific aspect of LookML related to a measure I'm working on. My goal is...
Filter OR condition / additive result / full-custom WHERE clause
I’m looking for a way to have my Explore’s generated SQL include a WHERE clause that includes OR logic. This w...
custom table calculation function
Hi,We are doing a lot of calculations with Looker outputs.Recently we're doing AB testings.I want to create cu...
Want to use filter value in liquid IF in dimension SQL field
I want to access the value of a filter on a dimension inside a liquid IF statement in a measure SQL line.I kno...
How to have one view for multiple database tables
Our database is set up with a different schema for each customer, but the table structures are identical. For ...
how to get database name in Looker
I would like to capture database name in looker. How can we do that? I see there is way to capture dialect via...
String to date conversion on looker custom filter
Hi everyone, Am trying to make a custom measure and adding some custom filters for counting a measure as follo...
Filter Suggest Dimension from Liquid Parameter
Hi All,I am creating a dynamic comparison tool which allows users to select a granularity to compare a selecti...
Explores with conditional joins using liquid variables started including unused views in queries
Hello, We have a couple explores that are set up so additional views are joined to the base view and also cond...
join views by running agreggations in each view separately before final join
Hello, I would love to speed up some looker dashboards by updating our data models. Here is how data looks lik...
Rebuilding Incremental PDTs
I’m trying to force rebuild an incremental PDT from scratch without needing a change to the PDT’s lookml. The ...
Best practice to set up data to aggregate over rolling 1d, 7d, and 28d time periods
Hi all! I have a table with a set of user_ids and various activities/boolean values for them. We want to be ab...
Nested dynamic parameter
Does anyone know how to nest a parameter? Instead of having a single parameter with 6 values, we want 2 parame...
Copy Paste when cross filtering in Looker
It is common for our users to click and drag to select a range of data, copy and paste in LookerWe have dashbo...
Dashboard Filters: How to set them dynamically?
We are having a dashboard with two filters of type date:Report DateIs there a way to by default put this on th...
Looker Filter Suggestions not passing Parameter into Query
We’ve just started experiencing an error on the Filter Suggestions call when trying to pull up suggestions in ...
Looker Access Filters
Hello,For my job, I am updating a model with an explore extend. In that extend, I am joining the base explore ...
(Financial) Dashboard with comparison between two days, and update filter based on another filter
Hello! I am new to Looker, however not new to BI tooling in general. I have an OBT (one big table) loaded into...
"Expand tables to show all rows" option when downloading is not working
When downloading a report as .pdf, we select “Expand tables to show all rows” and the table doesn’t expand. It...
How To: Date Format Localization in Looker
Context There is no out of the box setting for date format localization as of 10/26/23 You can localize descri...
idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
How to copy views from one project to another project in Looker
I have some views in project 1 (will be deprecated) and need to copy them to project 2. Project 1 and Project ...
Charts like Stock Market
Hi,I am trying to create a chart that looks similar to a stock market chart , that gives you the value of a st...
Managing Schema Changes
The databases you connect to with Looker are not frozen in time - as businesses grow and evolve the way we sto...
drill two dashboards
Hi Teamhow can we apply drill through to two dashboards at a time in lookerplease tell me Regards,Fayaz N
value_format to show Duration in Days Hours Minutes Seconds doesn't work
I am trying to create a visualization to show the duration as dd days hh hours mm minutes ss seconds format. S...
