How to determine when Query Performance issues are caused by Database Bottlenecks/Settings?
There are many factors that contribute to slow Query Performance in the Looker application, one of the most co...
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
Manage auto refresh for a report doesnt work
I use Google Analytics Pro and I can't find the auto refresh featureIt does not exist under recourse
percent_of_total Question
From the docs: “percent_of_total calculates a cell’s portion of the column total. The percentage is calculated...
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...
Is there a way to view LookML Dashboard usage?
Anyone know if there is a way to track usage/views/queries of LookML dashboards either directly or indirectly?...
Displaying null values in sums
Looker Coalesces by Default By default, Looker coalesces sum measures with zero. This gives us a nice “0” disp...
Slider Parameter
HI there,I am trying to create a slider style parameter. So in the slider I need a range of values, say 0 to 1...
Currency Conversion Parameter and Formatting
It’s common to want to switch between currencies in Looker. This is usually achieved by having your results/ta...
How to convert time duration(Ex.. like 1d 5h 12m 25s from 55678900 seconds )
Hi,i am a looker developer i need to create one look.i have a dimension called duration,dimension: duration{ty...
Order of displayed filters
Is there a way to specify the order of the filters displayed in dashboards?Ex: I have a filter on countries. A...
How to display text string with html tags as html
I have a simple string dimension that contains html tags. When I display in Looker it treats the dimension as ...
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...
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...
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...
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...
(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...
idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
