Fixed variables (like a parameter) in LookML
Let's say that I have several measures in metric units, and I want to recreate the units for imperial units. I...
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
Dynamically changing looker connection inside model file
I have been trying to dynamically change the looker connection using user attributes. Here the database connec...
Tableau to looker Migration
Hi there, We are planning to migrate to Looker from Tableau.Instead of creating model from scratch, I am curio...
View Dashboard not available in developer mode
I have created a dashboard file by copying the LookML definition from a dashboard I had built. However, when t...
Drill down on dimension vs measure
I am using drilldown and inside that I want to show four columns can we decrese the width of drilldown columns...
Setting label_from_parameter on dimension_group
HelloI am trying to set up a time grain filter on my dashboard. To do so I set up a parameter such as:paramete...
"include: references a project not in the manifest"
Hi thereI am doing a big cleanup in our Looker project. After a lot of deleting, I’m getting tons of errors wi...
Why Looker filter field with suggestion run a query for each letter entered?
In Looker, when using a filter field with suggestions (e.g., company_name), placing the cursor in the box imme...
Dashboard and Look versioning
Is there any way to use version control in Dashboards and Looks with Github?I'm facing a challenge of maintain...
Abnormal Forecast Results
Morning!When adding a prediction/forecasting feature into my looker graph, the results are impossible to justi...
How to set up interactions between different elements of your dashboard in Looker Studio
Hello All,In Google Looker (Looker Studio), can any one suggest how to set up interactions between different e...
If function not working in Edit Table Calculation
I am trying to create table calculation for monthly targets.Getting expression incomplete error:${f_submission...
Save and re-use the preferred date format across the project?
Hello community!I have found some examples of how to format dates in a way that it aligns with the preferred d...
How To: Date Format Localization in Looker
Context There is no out of the box setting for date format localization as of 10/26/23 You can localize descri...
A filter that depends on the parameter
Hi everyoneWe would like to have a filter that depends on the value of a parameter, for example we create a pa...
Convert text to Date
Hi i have a google sheet that is the data source for looker. One of the dates is inthe following format - 11/2...
GCS Bucket Locations + BQ Dataset Locations optimal set-up for EU. Should GCS and BQ follow same loc
GCS Bucket Locations + BQ Dataset Locations ==> optimal set-up for EUWhen looking in isolation, below set-ups ...
Using liquid parameters in SQL breaks filter suggestions
Hello,I am writing custom SQL to define my table in Looker and I’m trying to filter date within the look using...
Default Visualization for Quickstart
Hello,I’m attempting to create a quickstart that’s simple for my looker users. When I click on that quick star...
Time Intelligence & Comparison: best practice for code modularity
Hi,what is the best practice in terms of code modularity for implementing time intelligence & comparison such ...
custom table calculation function
Hi,We are doing a lot of calculations with Looker outputs.Recently we're doing AB testings.I want to create cu...
How to create a single value chart with trendline / sparkline for a KPI
I am working on creating an executive level dashboard and would like to create a single value visual that show...
Creating and updating a temporary table in LookML
I am trying to create/update table/view inside a SQL based derived_table in LookML. Is that possible? I keep g...
Looker Access Filters
Hello,For my job, I am updating a model with an explore extend. In that extend, I am joining the base explore ...
Drill Down Issue
I am trying to create a collection of fields for drilling down in an explore and hitting an issue. I have an e...
Not able to create a project in Looker despite Admin Role
Hi Team,I have admin role in Looker. But when I try to create a new Looker project, I encounter Looker access ...
Merge Queries
Hey,We are trying to do a merge query but it isn't producing any results. We are joining the explores on an ID...
Can I use a user_attribute for dynamically change model names inside dashboard files?
Hello,We are currently using a single Looker instance with three different projects (Dev, QA, and Prod). Each ...
Pagination in Looker
Some old-school reporting use-cases may require viewing more than 5,000 records. Since Looker sets row limits ...
'Datagroup Maintenance Schedule' vs. 'datagroup- max_cache_age'
if I have defined max_cache_age in datagroup within a model say 'A' and we also have Datagroup Maintenance Sch...
