Drive Decisions Faster: The New Era of Period-Over-Period Analysis in Looker
Period-over-period (PoP) analysis – whether you're looking at year-over-year, quarter-over-quarter, or month-o...
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
How to keep a LookML view created with “Create View from Table” in sync with BigQuery schema?
Hi everyone,I'm using the “Create View from Table” feature in Looker to quickly generate LookML views from Big...
Date fields throwing error
My dimension group of date is apparently throwing errors when included in the dashboard. Can someone help me r...
YoY/PoP Implementation Help?
Hello everybody, for the past two months, the bane of my existence has been trying to implement a PoP solution...
Setting up Looker Links to Dashboards and Explores through Liquid Automation
What is DrillingWhen you’re exploring data, I like to think of drills as being either having horizontal qualit...
How to extend existing model from one connection to the other?
I can see the VIEWS and MODELS coming from the source through remote dependency, but I am not able to use EXTE...
custom view in looker
Good afternoon Team!I would like help importing views from the Github community. I managed to do so through th...
Looker Dashboard Filter Warning for Historical Data Selection
Hello Looker Team,It sounds like you'd like to implement a warning message in your Looker dashboard filter. Th...
Logic not working
I can't see my current shift logic working and stops all the time. In the column where it has to come 1 for cu...
Only measuring the "latest" values
What’s in a measure? All too often, we limit ourselves needlessly when we equate measures, metrics, or aggrega...
Dynamic Connection Switching Based on Development Mode
We currently have two database environments: prod and preprod. At the moment, our Looker instance connects onl...
Is there an easy to get to lookml of the Explore (ie not the View)?
From an Explore, it's easy to see LookML of a dimension/measure/etc and get to the View file where the dimensi...
Cache Invalidation
Hi,In admin sections, I am reviewing Datagroups to monitor caching resets. However, although there is a cache ...
URGENT - Semi Additive Measures - No LookML solution
Please provide a solution for Semi Additive Measures inside Look ML without any pre-calculation, derived table
URGENT - Semi Additive Measures - No LookML solution
Hi Team,What is the straightforward way to implement Semi Additive Measures in LookML using functions and calc...
Use Looker System Activity data in our own LookML models
I am wanting to use the Looker System Activity models in our own model in LookML in order to combine it with o...
how to escape a special character in my dynamic URL
Hello , I’m having an issue in which I have a parameter in my URL , for the most part it works well except one...
view with multiple table access which reside in different database
We have custom react application running on looker instance. Currently we are facing issue for solution we nee...
Configuring Looker for many single tenant data sources
We currently store client data in a single Looker database, and use a single connection to serve data to clien...
Need a way to incrementally build a PDT that's using create_process
Hi Everyone,We have a PDT that is built using create_process and contains a few sql_steps. This PDT is becomin...
How to filter a measure with HLL Sketch fields
Some customers create fields in BigQuery with HLL (HyperLogLog functions), which create a sketch of a count or...
Creating couple columns from a single nested field
Hi,We store event log properties in nested fields, as shown below: dimension: message_number { type: number vi...
I want to create buckets based on a measure in Looker. Can you help me write it ?
I'm trying to run this, but I'm getting an error because I can't create a dimension based on a measure. Can yo...
LookML creating a dynamic label from multiple parameters
Hello, I am trying to create a dynamic label for a measure based off multiple parameters.The end user should b...
Limitations on number type and value_format
The Looker version we are currently on is 7.18.21Are there inherent limitations when using number and/or value...
reading a filter and setting a second filter dynamically based on the first filter
I have this code:view: salesPurchase_meas {extension: requiredfilter: currYearTmp {type: string suggest_dimens...
How to create a measure in LookML based on different views/explorers
I have created two views from a table with some implemented measures. It's something basic, illustrated as fol...
Creating a dynamic URL that links to different dashboard
I’m trying to link two dashboards together because it seems like looker doesn’t support dashboards having sepa...
SQL Runner gives the graph I want. Looker Explore completely breaks it.
I'm trying to create a simple line chart with multiple lines, and none of the options in the Edit allow me to....
Conditionally format each cell based on a Table Calculation
Hello,Is it possible to conditionally format each cell in a table (with a Pivot Field), based on the output of...
