Select all Filter option
Does anyone know how I can achieve this? I’m trying to set up a SELECT ALL filter like the below on looker. Ca...
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
Removing Single Quotes from a String with Liquid
Working with strings using Liquid can be a very powerful tool within Looker, but it also can add another compl...
Look ML Developer Exam
Hi, I am planning to give LookML Developer exam and was wondering how many questions are there in the exam? Is...
Context Comments
Please see this documentation page for comprehensive information. A labs feature to add a SQL comment to the b...
What is the looker recommended folder structure for LookML development ?
With different type of files (objects) like models, views , refinements, explores, datagroups , what is the lo...
Can tables within the same schema become a filter?
There are many tables in our database having the same structure, and all of them need to add some customized m...
Add Multiple URL's in Looker (Or Alternatives)
Hello Community,I am trying to map_layer parameter to add custom EU (DACH) map. I am not able to find TopoJson...
Filter replicate sentence where field1 in (select field2 from table2)
I have a big problem with Looker, I need to do a filter in Tile or LookML seems like sql query sentence. It’s ...
[Analytic Block] Simple Funnel
About This Block A simple funnel is a great way to look at events or transactions. Starting with just a few ev...
Applying HTLM to table totals
Hey Looker Devs!Is it possible to have the HTML conditional formatting apply to the totals that are shown in a...
DATE_TRUNC timestamp to week in SQL Runner
Hello, I’m using SQL Runner for the first time and am attempting to roll up a series of dates into their respe...
How to create table calculation for measure or field group by one dimension
Hi team,I have three columns ColumnA, ColumnB and Measure in Explore. I want to aggregate sum(Measure ) group ...
HTML rendering in new dashboards
Has anyone else had issues with HTML rendering differently in the new dashboard experience? The spacing looks ...
Accessing Looker Data Dictionary through Looker API
Hi All, I would like to move all the information found in the Looker Data Dictionary of my project into a csv ...
Using a field from a different view
Hello All,I have a view called patient, and a view called risk. Risk has a foreign key patientId to patient, a...
The filter "Xxxx" is not allowed when using liquid parameter in dynamic derived tables
Hello,I have a problem, I am trying to dynamically query column from the database, I wish to create a paramete...
BQML blocksを使ってLookerでBQMLしましょう
※ 本投稿はLooker Advent Caledar 2021 22日目の記事です。年末にお小遣い稼ぎをしようと、株を買ってみようとしたんですが、せっかくなのでLookerでBQMLを使って予測した結果を元に売り買いし...
Learning videos
Hi, is there any way to access videos separately (as it used to be), without the learning modules combined for...
Filter Error Handling
Is there a way to seamlessly handle when a user enters the wrong information into a filter? IE: They put. text...
Downloading Visualizations in Excel
After creating a Dashboard, I tried to download one of my visualizations(Line Chart) in Excel format but it do...
Issues using dates condition in WHERE clause
@here, Hi all!!!I’m using the following sql script to obtain the top N from different categorical variables.I ...
How to calculate Sales Date dimension
I have one date dimension_group “transaction_date”(Year, month, month num...) and one column sales. I need to ...
Filter a dimension by a measure
Hi everyone. Is it possible to filter a dimension by a measure, like we would do using “having” in SQL?I know ...
How to convert hour in number to human readable like 1 AM, 2 AM ..
Hi team,I have a date dimension group which has date in raw form. I need to convert below chart which has hour...
Display No results as 0
I am trying to rank top 10 countries by total billings in exact period. One of the countries does not have any...
Substring value condition | Custom filter
Hey! I’m trying to apply a customer filter based a substring of a numeric id.As I need to apply the ‘less than...
.kml files to Topojson
I have a file in .kml format and when I convert to Topojson, I am having issues displaying the polygon on a ma...
How to set up a link on a data column
Hello!I’m looking to attach a URL onto a column of data so that when it is clicked, the URL is opened inb a ne...
Creating a custom metric with 2 measures
I need to Create a custom metric of errors per hundred total requests to see how it is performing. Errors and ...
Creating a field that captures the earliest value from a set of rows
Hi Good Lookers! I'm trying to create a new dimension that extracts the earliest year from a date field associ...
