Run Inline Query API Call - Row Limit
Has anyone else noticed a change with the row limit for the API for run inline queries? We used to be able to ...
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 implement DatesYTD and DatesMTD using LookML
Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_...
Am I able to use liquid filters to determine the value of the 'hidden: ' field ?
I would like to use something like this so that I’m able to hide dimensions based on the name of the view. dim...
Not able to see the filters in Explore in Edit Mode
I have a dashboard, In which i have 4 looks. I was asked to apply a date filter on it. When I added, it worked...
Al migrar mis queries hacia Looker no funciona 'position'
Cuando intento usar position para generar una dimensión, obtengo el error: 'Query execution failed: - Syntax e...
Totals in merged queries results
Hi all, I know it's not possible to add totals to a pivoted merged queries result but I wonder if anyone has y...
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...
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 ...
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...
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...
