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...
Forum Posts
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...
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 ...
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...
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...
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....
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...
i Want to manipulate "period Control" filter in my looker studio
I have a report and need to be able to manipulate the value of the "Date Range Control" field. I need to get s...
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...
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...
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,...
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
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...
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
Using LIKE operator for parameter in derived table
It's similar to this thread https://www.googlecloudcommunity.com/gc/Modeling/Using-LIKE-operator-and-wildcards...
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...
Filter OR condition / additive result / full-custom WHERE clause
I’m looking for a way to have my Explore’s generated SQL include a WHERE clause that includes OR logic. This w...
String to date conversion on looker custom filter
Hi everyone, Am trying to make a custom measure and adding some custom filters for counting a measure as follo...
Explores with conditional joins using liquid variables started including unused views in queries
Hello, We have a couple explores that are set up so additional views are joined to the base view and also cond...
Best practice to set up data to aggregate over rolling 1d, 7d, and 28d time periods
Hi all! I have a table with a set of user_ids and various activities/boolean values for them. We want to be ab...
idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
ElasticSearch Data Connection
Is it possible to create a looker database connection pointing to an elasticsearch database? Specifically, is ...
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...