How to comment out a block of code
In order to comment out an entire block of code in the LookML editor, following these steps: Select the lines ...
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
Dynamic table name setting by using parameter for table with hypen
Hi team,In a SQL template, I am trying to dynamically set the table name using a parameter. Since it is a tabl...
List of dimensions available in a view
Hi folks!I have a specific scenario where getting a list of all dimensions available in a view into a Liquid v...
Avoid duplication of SQL logic of different measurements
Hello,In my project we have a lot of measurements which tend to share the same common SQL logic applied for a ...
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...
Same Datagroup in Multiple Projects
I have a question pertaining to an issue I'm encountering with PDTs in respect to datagroups and having multip...
Looker Aggregated Measure not displaying values in filter
I am trying to create a report by aggregating to Customer Group level.Issue:If I keep Collector Id as dimensio...
Work with Dates in Looker Without Unnecessary SQL Date Conversions
How can I configure Looker to handle date fields without unnecessary SQL conversions, while still enabling eff...
Potential bug in dimension type: date filter due to obligatory TIMESTAMP conversion
when using a dimension of type date,dimension: utc_created_date {type: datesql: ${TABLE}.utc_created_date ;;de...
Bug in date handling by LAB Faster Custom Dimensions
Im trying to do a diff_days(inventory_item.issued_date (timeframe group field date raw field is timestamp), in...
Use different locales for each timeframes
Greetings!I am currently applying a locale to my dashboards. Everything is working fine, except for that.I hav...
Order of Fields in Looker Explore UI
Hi All,As we create the dimensions and measures in Looker views and these show up in Looker Explore UI to enab...
Sheduling Advanced filters
Hi everyone!Im facing an issue in Looker that I'm not sure if its an expected behaviour or maybe a small bug: ...
How to change view for a visualization
Hello everyone!I am interesting if it is possible to change source for a visualization. For example I have rea...
"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...
LookML - how to generate week number in LookML
Hi there, i'm pretty new to Looker. Looking for some help please.Are we able to concatenate 'week' with CAST(W...
How to keep Bigquery Structs
Hi everyone,I have some tables in BigQuery with Structs (nested data); for example, I may have 5 rows with the...
Looker merge is taking a long time to show in production
Hi Looker CommunityWe're noticing that after merges in Looker, it is taking quite a long time to reflect in Pr...
LookML and dbt
Silja Märdla recently published this article on LinkedIn - Exposing dbt Models in Looker. She describes the db...
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...
Show link in custom dimension
I have a report that provides "Username" and other data about users. I use "Username" in many different report...
Dynamically adjusting connection based on user attributes
Hi! I'm working on a project to move our looker workloads from SQL Server to Snowflake. I'd like to be able to...
1 Dashboard, multiple user dynamic connection
Hello, I know everyone is facing the same problem and no accurate answers are given.I have 2 service account (...
Tableau to looker Migration
Hi there, We are planning to migrate to Looker from Tableau.Instead of creating model from scratch, I am curio...
Dynamic Fiscal Year Offset
We are using Looker embedded in our app to service multiple clients. Though most clients' use a calendar year,...
Totals in merged queries results
Hi all, I know it's not possible to add totals to a pivoted merged queries result but I wonder if anyone has y...
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...
Dynamically changing looker connection inside model file
I have been trying to dynamically change the looker connection using user attributes. Here the database connec...
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...
