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...
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
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...
LookML Developer Certification Exam
Hello all,Would anybody know if there are any (preferably free) resources to access past exams for the LookML ...
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 ...
No titles for LookML dashboards in System Activity DB
I was trying to get title of my LookML dashboards in System Activity/ Dashboard, but I only see wither titles ...
Do Anyone Have Best Resource For LookML-Developer Exam Preparation?
I am about to attempt LookML-Developer exam but without LookML-Developer exam preparation, i can not pass this...
Organizing your LookML into layers with our new refinement syntax
With the latest Looker 7.6 release, we are introducing the concept of LookML refinements. In this article, I’l...
Custom Filter w/ Dates
Hi,I’d like to filter results by Order_Date, specifically, “Order_Date not equal to today” … Can someone provi...
Creating reports without a LookML model
I’m keen to see if we can use Looker to generate/distribute report output, but without having to create a Look...
Custom Title to a visualization
Is there a way to customize a look title in a dashboard to be dependent on a filter?
Referrer source
I want to see where we are getting our referrers (links) from for source:SEO i put in in the past 1 year. but ...
How to calculate consecutive count (based on various conditions)
Hi Guys,Looker rookie here. I’m trying to determine a way to calculate a consecutive count and am not sure how...
[Analytic Block] AB Testing with Statistical Significance
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
Hiding an explore from a group that it's included in
Hi all,I have an explore, e.g. ExploreA, that is defined in its own .explore.lkml file. It appears in group_la...
after login into looker getting loading icon in broswer
HI Team,After successfully login into Looker with valid credentials.It is showing only loading icon.Can someon...
keep geetting: "columname" must appear in the GROUP BY clause or be used in an aggregate function
Hello !I am trying to do a case when using two measures but I keep getting the same error and already tried ev...
