How to subtract month in lookml
Can we subtract months form ${created_date} in lookml. Eg: ${created_date} - 13 Monthswhich should give me the...
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
Case/when based dimension: Want to filter more efficiently
I have a dimension that is defined as follows: dimension: product_id_group_biz { label: "Product Business Grou...
how to apply filters based on a list - user in (select distinct user from t)
heyi’m presenting a dashboard based on users action - i.e. calls to costumer case (CC)Imagine that i want to s...
Emulate a function call in LookML
Figure out this SQL code:SELECT client_id, fn_getComplexCalculation(client_id, DATE(“10-01-2020”), DATE(“10-01...
How can I drill down in Looker?
Hello! Let's suppose that I have a table with 2 columns: date and sales. Then, I created a graph, where the X ...
Adding Multiple Instances of an Extended Dashboard within a Single Dashboard
I am working on a dashboard (let’s call it alpha) that is using one report (daily_values), multiple times, but...
Filter to always have OR 'field' IS NULL
Is there a simple way, without going into creating separate parameters and sql_always_where to set a field to ...
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...
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...
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 ...
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...
