Dynamic Forecasted Measures
Scenario Predictive analytics and machine learning have been popular buzzwords as of late and can provide trem...
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
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...
Decimal
Hi, is there a Looker formatting option that excludes decimals numbers and does not round the result?For examp...
yesno dimension with several conditions
Hi folks, I must be extremely dense, but I can’t get this to work and I can’t seem to find an example here tha...
Dynamic field selector when we don't know the number of fields
Hi community! I have a bit of a tricky case. We want to give the users the option to select with a parameter w...
Using order_by_field with dynamic dimensions using parameters
I defined a dynamic dimension that I use as filter, as described examples here and here.For example one option...
Can you define order_by_field by multiple?
I have a dimension of type string that contains multiple numbers inside of the string and I'd like to order th...
Values on the week 1st day
Hi,I am trying to create a measure which only brings in value for the first day of the week.I tried to create ...
add dimensions as they appear in JSON column
We’ve got a JSON column with varied and often-changing keys. I want each of those keys to be a dimension.What ...
How to extract every 100th row in looker
Do you know, how to extract every 100th or nth row in looker?
Best way to replace table calculations for month over month retention/results
I need to track 3 data points month over month that all have to do with the volume of partners on our delivery...
Bigquery challenges
@EveryoneJust checking - what are major challenges - expected when we set looker via bigquery
How to set users permissions in a single table?
Hello all,I need to prepare an user matrix access and separate some fields in just one table for different use...
Combine Column Data
How would I have one of my columns list the data in a single cell instead of on separate cells?Example, trying...
