Feature Request For allowing all zip codes on map visualisation
Feature Request here for allowing the Zip/Postal codes of all the countries , cities and states currently in M...
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
Calculating the number of business/working days in a month excluding holidays,
Hello, Does anyone know if and how this can be done in Looker and what would be the best way of achieving this...
Liquid _in_query not working for custom dimensions
Hi!I have a set of derived tables where I use Liquid to include/exclude columns in the SELECT statement based ...
Creating two parameters, one dependent on the other
I am trying to create two parameters, one the selects the date granularity and then based off this, one that a...
How to fetch data from multiple databases of snowflake using single looker connection
I am trying to get the data from multiple databases of snowflake using single looker connection can anyone sug...
Dynamic column in derived table
Hi, I'm trying to create a dynamic column in a derived table but can't get it to work.In my main view file I h...
Looker
Hello. I need to now how to calculated in lokker, the percentage of non-attendence to an event Could you help ...
How to: Tuning your Looker Project for speed using only your Model file.
This post will explain how you can begin to optimize your Looker instance by tuning your Model file (no view-l...
Length of an array in lookml
dimension: tags {type: stringsql: ${TABLE}.tags ;;}get length of each array and filter empty arrays
user_attribute array in access_grant
Our clients can have an array of one to many personas, e.g. Accountant, Department Manager, Owner, etc. We wan...
Fetches data from Neo4j and creates a Looker view or data source
I want to create a connection with Neo4J Aura with Looker. So, that i can create looker visualization dashboar...
Is it possible to use GraphQL as a datasource of looker ?
Hello, we have developed a product that allows you to connect to data sources through GraphQL. What is the bes...
Date fields throwing error
My dimension group of date is apparently throwing errors when included in the dashboard. Can someone help me r...
Is pulling API data from an external service using the Looker dashboard possible?
This might be a naive question, but is it possible to have a looker dashboard query an external API? If i want...
How to filter a data in graphs and table
Hi AllI have more than 1000 products in my data. How can I filter just one product in graph for spesific perio...
Bug not resolved: bind_all_filters option in NDT persists
I am trying to drill down from a measure (count_distinct) in a pivoted table. The drill down fields work corre...
Unable to pull or push code on Looker UI using git actions
I am developing the views and models in my personal branch. After that I am trying to pull the code from produ...
Naming Fields for Readability
Dimension and measure names can get confusing, especially as models grow. Making the proper field references w...
Use Refinements to add Period over Period functionality to existing explores
Using Refinements to add Period over Period functionality to existing exploresIn this example, we’ll use refin...
how to convert number to string in custom dimension?
I used the to_string function here. But it doesn’t seem to work. And if I don’t convert it to string, the func...
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...
Dynamic connection string
Hi, is there a way to give the connection string in a dynamic way?for example, I tried creating a constant wit...
SQL Runner Query result visualization as a dashboard?
Can't I display the SQL Runner Query result visualization as a dashboard?
New field shows wrong values
I need to create a new field which shows only the users that reached a specific landing page of a website, wit...
Looker Custom Measure
We create a custom measure as a List of unique values The value that we try to get the unique values from is a...
GA4 to Looker data lag
I have a simple dashboard which includes graphs for purchase revenue and session medium.This is set to be the ...
GA4 Source/medium breakdown
On GA4 under the traffic acquisition report you can change the dimension to source/medium, however in Looker t...
LookML architecture/organization (w/ multiple customers)
What’s been your experience in organizing your lookML, specifically when provisioning reports to different cus...
SSO Embed localisation
I've seen this post (https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/SSO-Embed-locale-localisati...
Can I use a user_attribute for a filter title on LookML dashboard?
hello, I have a customizable dimension label based on a user attribute and I am having trouble using that valu...
