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...
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
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...
Column level security in look ml
Hi Looker communityI would like to have column level security on Look ml per specific tenant id - what would t...
"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...
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 (...
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...
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...
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...
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...
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...
