Field Names on X-Axis (Line Chart)
Hi there! I'm returning to Looker after a few years for a project and I'm stuck on getting it to format this c...
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
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...
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...
"Error switching into Development Mode" message
I have the developer role on a Looker Instance. I can see the project and its associated LookML in read only m...
Column has [object Object] values instead of dates
Hello! I'm trying to convert a string column to a date. (We use Trino for querying the data in Looker)The date...
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...
Text Wrapping / Fully Qualified Naming on send/schedule view
Hello! Is there any way to either wrap the text or just display the field name in the send/schedule filtering ...
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...
Creating a Confidence Interval based on data from a column
Hello Im trying to create a Confidence Interval but have no idea how to proceed. The CI is based on data from ...
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 ...
Dynamic value format name
I sent it to Looker support as well but I was wondering if anybody has similar requirement. I have 30+ measure...
Creating hyperlinked button dimensions
Was looking for a way to improve UX for end users when creating dimensions that link to other URLs and explore...
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...
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 ...
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...
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...
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...
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...
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 ...
