How to create a group by measure using LookML?
Hey,I have 2 steps of a calculated field -First step, I created a derived table that calculate ccy_usd_amt gro...
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
Filtering dates 'in the past [X]' - Looker inserts empty string into CURRENT_DATE('')
Hey all,I’m trying to figure out this weird error I’m getting. When I filter my dates with ‘is in the past 5 m...
DB Connection types in looker
Hi Team,I am I am very much new to looker and we are in process of migrating from Tableau to Looker. I would l...
Concat strings and special characters in lookml
Trying to concatenate dimensions and separate them with a space or dash but when I add in the character the ne...
Conversion fail when generating LookML view from table
When trying to create views in Looker from a table (located in BigQuery), i sometimes get this error and the l...
How to calculate cumulative totals on a measure in a pivot table?
Is it possible to define cumulative measures in a table? Or at least have a pivot table show cumulative values...
Native Derived Table > Auto-gen LookML for existing Explore table calcs
Hi Folks,Looker newbie, apologies in advance.I’m hoping to build a native derived table, to aggregate the resu...
Liquid Parameters - One value change all
Hello everyone,I hope you are all doing well. I’m still quite new to looker and haven’t been able to figure th...
How to add an absolute date filter to a measure
Hello,I’m trying to add an absolute date filter to a count measure but it’s not working.I’m addding it like th...
DropDown in Looker
Hi All,Can anyone will please help me understand that is there any option available in looker by which we can ...
Conditional Formatting of Time
Attempting to change my “elapsed time” column to show anything in red that is older than 3 hours (0:3:00:01). ...
Marketplace Dialect Rewrites
Hello Looker Marketplacerinos,I would like to deploy a marketplace block, but for a different SQL dialect. It ...
Use of raw for joining dates
Come across this (not for the first time) on trying to improve performance in my previous post.I have situatio...
pagination in looker
Hello everyone, I would like to know how I could make a pagination of an explorer and not only show the limit ...
Trending Data Back for Previous Days
Hi all,Hoping someone can help me - I have a simple SQL query that pulls a count of customers for the current ...
Filter when
We are moving from SAP Business Objects to Looker , one of the features of that tool is something called conte...
Global Maximum Date
I want to create a view that will have multiple time bucketing options available for the end user, such as YTD...
Dimensions from DT empty
Hi all,I think it’s a simple question but I do not understand the logic. Please find below the example.Main vi...
Which developer changed a LookML model
Hi all! There are a few people on my team that have the ability to go into development mode and work with the ...
Two tables in Redshift, how to combine in same view
I have two tables in redshift. I want to create one view that will allow me to manipulate dimensions and measu...
SQL Runner: dummy columns in Spark tables
Hi guys!I ran into a problem while fetching the schema of a Spark table in SQL Runner. As I can see, Looker is...
Create a "Location" dimension/measure in looker to plot on map given address, city, postal code.
Hi There,I’m new to Looker and was wondering if you can create a new geographical field using LookerML? I have...
Presenting totals as Group level figures
Hello,Is there a way to display the Group as a sum of different entities? For Example: Having the countries AT...
Aggregate tables setup
Hello, I’m new one with looker and i’m trying to understand best practice for my task.I have “actions” table t...
Aggregate Awareness via Looker API?
Hi Looker Community,So I’m trying to build more and more Aggregate Awareness tables for my company, and I’m se...
Is there a way to exclude the value selected from a liquid parameter from a measure
For this issues I have a measure that will calculate the average rate based a users selection, since this will...
Year-on-Year, Point in Time Comparison
Hi all, I am relatively new to Looker but not to SQL and hoping someone can help me with an issue I'm having. ...
Calculate the timedifference between two date_time measures
HiI have a table looking like the one below. Start Time and End time being measures, and days, hours and minut...
Last 14 days user population
Hello, I have a dimension called activity_day which is just a column of daily dates from 2020-01-01 to 2021-12...
Dimension using other view that is joined many times
I have got a database with a very strange order architecture in which any order might have a parent. Sometimes...
