Variable to use in a Query
Hi,I would like to create or define a environment variable/s to add in a query , this variables should be get ...
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
Adding condition for Length to differentiate shorts and long video
Hi all, Im creating a Looker Dashboard. I would to create a conditional field where anything less than 1 minut...
Filtering records based on a user specified date that falls between start date and end date fields
Without creating a derived table, is there a way to filter records in Lookml based on a user-specified date wh...
Not able to see the views on Explore
Hi All, I have 2 views. When i go to looker -> develop -> then these views are visible to me. But, when I go t...
Select fields dynamically from a filter to use in a dashboard visual
I am trying to add fields (more than one) dynamically from a filter (which has a list of fields defined as a m...
compare the sum
Hello! I want to do a simple thing:I have Columns "women" and "men". I want to compare the sum of numbers in t...
case when condition for replacing null value to string and non-null values to keep it as same.
Hi team,I am trying to execute the below condition which is if the column has null values (∅) symbol, I want t...
Custom preset for a dashboard filter
I want to have a predefined collection of custom filter values for a dashboard. Something like configure defau...
connected model to another model
Is it possible to have one model which is connected to an other model ? I've my modelA which is connected to B...
Dynamically adjusting connection based on user attributes
Hi! I'm working on a project to move our looker workloads from SQL Server to Snowflake. I'd like to be able to...
Filter Max Date by different timeframes
Hi! I have an unusual use case that i would like to resolve. I have a BigQuery table that has information week...
Filter last n months
If the current date is April 9, 2024, which days in the past 3 months will it retrieve data?I dont see documen...
order_by_field function is not working
order_by_field function is not working when pivoting a dimension and when using new_lookml_runtime: yes. A ver...
Default Visualization for Quickstart
Hello,I’m attempting to create a quickstart that’s simple for my looker users. When I click on that quick star...
How do I give a user access to a specific explore?
Hi,So I am a LookML developer and Im not that good yet with access. We have a lot of different explores which ...
How to create a measure in LookML based on different views/explorers
I have created two views from a table with some implemented measures. It's something basic, illustrated as fol...
Date Parameter Default Setting to yesterday
Hi there,I’m quite new to Looker (a few weeks now) and got stuck at a Parameter default topic.The parameter is...
How to PoP
https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Methods-for-Period-Over-Period-PoP-Analysis-in-L...
Pull Field Labels & Descriptions from separate tiny table?
Long story short.Have a survey with many questions - say 20.Each question is a column - I know it can be done ...
Symmetric aggregates overflow bug?
Here is some lookml : view: debug_test_1 { derived_table: { sql: SELECT '14d' as id UNION ALL SELECT '13d' as ...
Dynamically apply calculation to all table values
Hi everyone!Little stuck on on something…Image that there is a table with one dimension with a bunch of measur...
Dividing between two values in a table
Hello,I have a table with two columns (with data pulled from Google Analytics): event action and total events....
Inaccessible view despite views being joined in explore
Hi, I have created a new dimension "dimension_one" in my view "view_one". This new dimension references fields...
Change looker Default time zone to EST
Hi,I am looking to add a filter on date: Idea is to get real time orders from order table (local time is EST)M...
Only measuring the "latest" values
What’s in a measure? All too often, we limit ourselves needlessly when we equate measures, metrics, or aggrega...
Configuring a dynamic explore_source in Native Derived Table?
I’m trying to make a generic view to allow “Top N” rankings on pivotted Looks (eg. line-chart timeseries). I’v...
Is it possible to assign date_start to a liquid variable
Please see my reply comment left in this thread . I am basically trying to do exactly what OP did by using liq...
Comparing Dates with Liquid
Usually, if we have a case in which we need to compare dates within Looker , we do that using SQL (like filter...
Creating a dimension % of a total
I have categories of revenue loss as dimensions per month with their monthly value, and I need to calculate th...
Collapsible Text or Markdown
I'm trying to make my dashboards cleaner. Currently we have descriptions that are important for users that are...
