Finding top 10 performers each month without table pivot
I read the “How to Find the Top Performers Over Time with Table Calculations” article (https://help.looker.com...
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
Reuse reference tables in lookml
Just getting started with looker and building our first model. We have reference/dimension tables in our datab...
How can I calculate percentile?
Hi guys! I need to calculate percentile in my dashboard, but I need to estimate this in the range date. e.g., ...
Date Parameter In a LookML View
I have a LookML that is powered by a big query view where the dataset that I am pulling from is partitioned on...
Select multiple fields with one click
I am wondering if I could create a field/parameter/group that when selected in the field picker or filtered by...
Liquid Filters Documentation
I stumbled across this reference at the bottom of the liquid variables reference page for handling filters as ...
Percentage Change
How to calculate percentage of change based on filtered time period(between two dates) selected by the user on...
How can we automatically populate a parameter allowed values from another view dimension ?
Hello, is there a way to populate a parameter allowed values from the result of an sql query against another v...
LookML does not update automatically - View BQ or dbt
Hiii I have a question (maybe I’m late to the party) regarding Looker update from a view… If I’m connecting ...
Hovering over a datapoint in a table
I have many drill fields across my dashboards but it is a hassle that I have to click on them to see the data ...
(World N0-1)! To Pass Google Looker LookML Developer Exam Guide
Pass With 50% Discount On Google Looker LookML Developer LookML-Developer Exam Certification I hope this post ...
How do I sort by combination of columns in looker?
I am having issue on sorting column based on combination. We can sort on visualization on front end but the ch...
Period Analysis Past Quarter data
Need help in getting past 4 quarters of data based on the filter selection on dashboard.In the source table, w...
Odd behavior with yesno dimension
Hello!! I have a Looker report that uses a view. It relies on a derived table built thuslyview: cte_seller_rev...
Time Series Filtering
I'm running into an issue that I find quite strange:A Time Series Visualisation is running in a couple of seco...
Exceeding URL row limit
It seems that URL links only offer up to 1000 rows regardless of the initial row limit set within Looker, anyw...
New field in mongodb view not being shown in Looker
Hello,My Looker Tables are connected to Mongo db views.I edited the mongo db view, by adding a field.This new ...
Create “Last Year This Month” measure
Hi team,I have one measure Sales and one dimension_group. I need to create “Last Year This Month”. So it shoul...
Combining Different Dates into Looker Table
Hi Guys,I curious how to go about implementing counts/sums when I have different dates in my data.Data Structu...
can we create an explore from sql query
I just wanted to know if it is possible to create explore from SQL query using SQL runner
Select Count Having Count from Another Table
Returning a measure filtered on a measure from a joined explore could return unexpected results. For example i...
Defining custom drill fields for a dashboard rather than using one defined for measure in lookml
Is there a way say we have drill fields defined in one of the measure having a set of 10 dimension but for a n...
Custom Timeframe: half-year?
In our organisation we do some reporting based on 6 month intervals: [April - September] [October - March], es...
Using HTML embed but prevent new tab from opening
I’m created embedded html links, but Looker has middle clicks of the mouse open the links in a new tab. I don’...
BigQuery clustering in non-case sensitive models
I am working on a model connected to BigQuery where our users also require non-case sensitive filters. In orde...
Dynamic Forecasted Measures
Scenario Predictive analytics and machine learning have been popular buzzwords as of late and can provide trem...
SQL query optimization for derived tables
I’m trying to run SQL RANK() OVER function on top of my existing table to remove duplicated rows of BigQuery t...
Count Distinct without data on table?
Hello,My case is very simple. How do I count the amount of times that X has Y without having it on my table?Ex...
How to count rows in one column separately for each type of rows in other column using SQL
HelloI need to count a number of rows in one column that respond to one from two types of rows in other column...
Including User type in a filter
I need to take a user role (i.e., Viewer versus User) into consideration when making queries. How can I check ...
