Hiding fields from a view in different explores
Hi I was merrily using fields: or fields: [] in the joined view of an explore, when I wanted a restricted set ...
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
Is it possible to create a filter that let you choose different dashboard versions?
Hey! My goal is to create a filter in a Lookml Dashboard that allows the user to switch between Version 1 and ...
How to give different name for one dimension
Hi, What are various way to give different names for one dimension.Dimension X have a label "nameA" I want nam...
Displaying both entries of a duplicate ID
I'm able to display duplicate values by adding a count measure that's tied to my field hash id. I then added a...
Using the BQ Info Schema Block
The BigQuery Information Schema block has, broadly, two main uses: monitoring and optimization. This article w...
Index weighting calculation
I am trying to perform an index weighting calculation, using the formula (Value in Cell * Grand Total of Grand...
Circular dependency from derived table error
I am getting the follow error: "Circular dependency detected from derived table to source explore"I have my ma...
From Sample to Real - 5 Steps for Your First LookML Project
This article will guide users who are new to Looker to accelerate their first LookML project by building from ...
Dynamic Time Granularity - opinions
I am very curious about people’s opinions on this topic: Looker Help Center Dynamic Timeframes for Dimension G...
Change design and add text to Run / Load button on dashboards
When you open a Looker dashboard for first time and start selecting some filters to update the dashboard with,...
filter dimension by an another dimension
Hi all,How to resolve this use case.I have two dimensions Y et Y and I want to create a new dimension Z who di...
Change Query by free typing in dashboard
Hi all,I want to change query by typing in dashboard level. Like There's some filter window in dashboard.And l...
bug - edit readme shows recent file instead of readme
seq:- open any file in looker but readme.md (say abc.view.lookml) - file will appear- open readme.md - file wi...
Number of arguments does not match for aggregate function COUNT
I am creating a LookML dashboard which requires some measures that are calculating a COUNT_DISTINCT on two fie...
View Usage
Hello!I wonder if there is any way to check if a view is being used and where it is being used. I'm rebuilding...
Primary key required in each View refinement?
I’ve noticed that Looker complains that my refinement views do not contain a primary_key dimension, despite th...
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...
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
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...
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...
