Date range filter based on lastest data
Hello guys,I'm stuck with date filtering- Please suggestThe data is stored in BQ as Month end dates and we hav...
Forum Posts
How to avoid unnecessary join
Hi, I have an explore in which I join a view, say view1 to another view, say view2 like so:explore: view1{ joi...
Data trigger runs on 1st day of month instead of last day of month
Good Day Looker Community Hoping to get some assistance with the below trigger that I have created.Goal: Looke...
Liquid variable
Can i use this logic in a liquid variable in an explore?{% if table1name.dimension._in_query and table2.dimens...
Alternative to a Right Join in LookML
I am tying to create a viz that displays inventory and sales data per sku for all of our products. As a simple...
Full Outer Join Primary Key Issue
Hi,I would appreciate any help related to the following situation. I have 3 views:Users - Unique table of user...
Building a Flexible LookML Model
Hi everyone,I'm seeking guidance on creating a LookML model that empowers end users to construct dashboards wi...
I am looking to create a Calendar
i wanna create a calendar con i can visualize the time off of my employees, is it posible on looker?in a calen...
analyzing customer journey with events data
I just wanted to share something I built recently to analyze a customer or user journey using events data: Thi...
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...
Potential bug in dimension type: date filter due to obligatory TIMESTAMP conversion
when using a dimension of type date,dimension: utc_created_date {type: datesql: ${TABLE}.utc_created_date ;;de...
SQL Runner Bug?
Hello,When using SQL Runner from the Develop Tab, if I run a query on a table as follows - SELECT TOP 10 * FRO...
Percentage change between two rows in a table
Hello! I have been trying for several days to make a table whose columns are some metrics such as impressions,...
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...
Best Practices for Connecting Looker to Data Warehouse?
Did you all use data engineers to create the pipelines, or did you use a dedicated reverse ETL platform like C...
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 ...
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...
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...
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...
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...
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...
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....
LookML concatenation with space in between fields
Trying to concatenate dimensions and separate them with a space or dash but when I add in the character the ne...
Keyword Labeling
Hi! I want to label Google Search Console keywords in Google Looker Studio. I tried doing to do so using a CAS...
Looker Over Complex Queries
Hi, I'm having an issue right now in looker where I have an explore based on one table let's just call it "amo...
Uniqueness test generates wrong SQL with count(distinct)
I have a model, where videos is main table, with playbacks joined to it. Each playback has playback_key (set a...
How to convert number to time in looker
Hello Team,I am query regarding how to convert measure with number data type to time data type in the form of ...
Date Dimension with Global Holiday Calendar
Hi,I need data about all holidays and days off in world.I'd like to get example script for all tables
Which would be the best 3D modelling software available in the market?
I am currently pursuing Robotics Engg. I had question in my mind that, which would be the best 3D modeling sof...
Regarding LoolMl
How to translate Lookml code from snowflake to Bigquery