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 ...
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
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...
Looker dimension_group with type time is changing my timestamps back a day, why is this happening?
Recently, when I have been using the dimension_group with type time, it has been reverting my dates back a day...
Is there a simple way to always filter out where _fivetran_deleted = 'true'?
We are using Fivetran to sync our production data with BigQuery. However, when data is deleted in production, ...
Looker block search ads 360
Hi! I wanted to know if anyone else here has used the Looker block for search ads 360 data, found here? I’m s...
Display Months Vs Days
HI I am playing with looker in creating different views/looks, I have a table that I currently working where w...
iframe embed filter value starting with # not working
We are constructing embed urls for our iframe along with all the filter values. All the filters work fine exce...
Add view with only dimensions from other views
I have an explore with 3 viewsview dimensionA page.idB event_loadedC event_loadedI want to make another view t...
Test for duplicates values
Hi all!I have just started using LookML and I wanted to create a test that will allow me to know if there are ...
Pass an external value to an embed URL as a filter
Hi All,How to pass arguments in public URL using embedded or is there a way to dynamically pass filter values ...
[Solved] Missing values for 'dimension' were not filled. It is unclear what values to fill for this field
So I have these lines that create cohorts: dimension: loan_purpose2 { label: “Purpose” sql: CASE WHEN ${TABLE}...
Adding Custom D3 Visualizations
Hi All,I would like to add some custom D3 visualizations to our Looker instance. I am very familiar with Looke...
Looker ML warning unknown or unexpected parameter "extension"
This warning has suddenly started popping up for our looker dashboards and was curious what may have caused th...
File content is overwritten
I didn’t miss that problem, thought that maybe it was fixed but not really:I was editing this file: /projects/...
Generating a Numbers Table in MySQL and Redshift
Postgres implements function generate_series, a function that returns a table of a set of integers. Unfortunat...
Looker is generating multiple SQL statements that are not separated by semicolons
HelloI am porting the marketplace marketplace_retail-block-v2 application to work with another database. It’s ...
Does Liquid Syntax in Unused Dimensions Execute?
I have a period over period block that makes use of a fair amount of Liquid syntax to cut down on the amount o...
Duplicating Tables for Comparative Analysis
Hello! My goal is to develop a benchmark analysis, a time-series comparison of a single customer’s measures to...
Fixing the Level of Details (LOD) of a Measure
We have the following hierarchy:Orders Shipments ItemsOrders include one or more shipments, shipments include ...
Connecting Looker to TimescaleDB
Hey there,I was wondering if anyone has experience with connecting a TimescaleDB (https://www.timescale.com) t...
Looker BA Exam
Hi all,I have the Looker Business Analyst Certification Exam in a few days.Do you know what exactly I should m...
Change Date format for Dashboard filter
Is there a way to change the default format for filters at dashboard level from YYYY/MM/DD to MM/DD/YYYY. I tr...
