Open dimension URL in a popup window
I would like to be able to render html inside a popup windowHere is my dimension:dimension: view_HTML { sql: '...
Forum Posts
order_by_field descending?
Is there a way to use the order_by_field parameter in my dimension, but specify that it should sort Descending...
Required Dimension in Explore
I’m building an explore that will be used for a very specific purpose, and because of this there are certain d...
Build LookML Objects in Looker: Challenge Lab
I am having problem with the ‘is_search_source’ dimension in the challenge lab. That s the only one that’s unf...
Add Date Field in Drill Field
I have an END Date Field in my View that I want to include into a measure drill field. The End date is defined...
Dimension Custom Sort
Is there any way to custom sort the Dimension in not alphabetical order besides of adding extra spaces in the ...
Coalesce two date columns into one
Hi there!I have two views that I’m joining in an explore. Each view has a `created_at` column that I would lik...
Query execution failed: - Function not found: TRUNCATE
I am trying to execute the Dynamic tiers from the documentation.https://cloud.google.com/looker/docs/best-prac...
Remove last 3 characters from a string
How do I remove the last 3 characters from a string in LookML? For example, I have “ownername2022:03:29”and I ...
Issue working with time fields from BigQuery inside Dimension in LookML
I have a TIME field inside my source table in BigQuery that have the time (hh : mm :ss) of my transactions:Whe...
Grouping dimensions using 'case when' grouping users lookml code.
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
html rendered_value in dimension not respecting date format
Not sure if it began today but I have the following set up for dates in my view:dimension: this_date { type: d...
Using Data Action with Dimension Group
Does anyone know if it is possible to add a Data Action to a Dimension Group? My use case is that I need to at...
Star schema tables to Looker model
Hi, we’ve been using Looker for 2+ years without any previous experience with this tool. We have all data stor...
Convert String ($1,234.50) to Number field
I have a string field that contains a dollar figure of total cost. It is a string field but I need it to be nu...
Convert String (yyyy-mm-dd) to Date field
I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-d...
Share custom dimension between different views to avoid rewrite
My use case is the following:I have many views with a “country” dimension that is populated with ISO-8601 coun...
How to create dimension from an array/struct in your table?
Hi all, I am relatively new to looker and have been learning my way on how to best utilise this platform. I cu...
Empty map drill overlay modal displaying only proper drill-fields for location-type dimensions
In case anyone else is struggling with this issue, I did not see another thread or any documentation of this e...
How to create a 'days prior to event date' dimension, to be used in place of actual calendar days?
I have a scenario where I want to compare the a the trend among multiple customer/clients leading up to a cert...
Can I create a Dimension or Measure for the earliest/latest date in a range defined by a user in an explore?
I want to create either a dimension or a measure that will capture the earliest and latest dates in a date ran...
Create a filtered dimension in LookML
Hello!I want to create a dimension within a view that is a filtered list of an existing dimension in the same ...
Create a custom filter that defaults to current week Sunday to Saturday
Hi Looker geniuses,Is there a way I can create a custom filter that defaults to the most current week from Sun...
How to convert table string column(which is having time stamp in 1609999 format) to date format in looker
I have table which hold timestamp in number format but the data type of the table column is string.How to type...
Does anyone know how to code custom dimension to get "week_end_date" as a new dimension? Versus week_start_date.
Hello Looker community,I would like to find a way to create a new dimension grouping data for a datatype date ...
Use dimension when creating measure with Case statement
I am trying to create a measure conditionally based on a dimension.My dimensions:dimension_group: date { hidde...
How do have wk. 52 show as 2021 and not 2022?
We have a dimension_group that extracts timeframes from a timestamp field. We want to compare year over year f...
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...
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...