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 ...
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
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...
Timezone conversion for a specific dimension
Hi,My Database timezone is set to UTC. I use mysql. The database version is MySQL 5.7.In one of the reports, I...
Convert minutes in integer format to "H: MM: SS" format
I have a measure that gives me the total minutes of use in a dashboard in integer format, i want to convert th...
Same Code in Dev and PreProd but Errors in Preprod Environment but not in Dev
Hello , I had an question on Looker different environment : I am using same code in Dev environment and Prepro...
BigQuery Data Transfer Service for Google Ads Partitioned Table Joins
Hello,I’m utilizing BigQuery Data Transfer Service for Google Ads to pull Google Ads Data then bringing the ta...
Looker Block Tutorial
Hi all!Can you share a link with me to on how to add a looker block to a project?Thanks
Creating a NDT column by concatenating two fields
Hello, I want to create a column in an NDT that concatenates two fields. view: ndt_sessions { derived_table: {...
