How to copy views from one project to another project in Looker
I have some views in project 1 (will be deprecated) and need to copy them to project 2. Project 1 and Project ...
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
Charts like Stock Market
Hi,I am trying to create a chart that looks similar to a stock market chart , that gives you the value of a st...
Managing Schema Changes
The databases you connect to with Looker are not frozen in time - as businesses grow and evolve the way we sto...
drill two dashboards
Hi Teamhow can we apply drill through to two dashboards at a time in lookerplease tell me Regards,Fayaz N
value_format to show Duration in Days Hours Minutes Seconds doesn't work
I am trying to create a visualization to show the duration as dd days hh hours mm minutes ss seconds format. S...
Passing constants at runtime
We have a lookml which uses a constant name for a project .. lookml sql code -sel * from @project.tablejust tr...
Remove Terms, privacy from app
Hello, I hope you are well. Is there a way to remove Terms, privacy, licenses, etc. from here? They show infor...
One Measure as pivot data one measure as Unpivot( single) data
view: my_view {measure: revenue {type: sumsql: ${TABLE}.revenue ;;}dimension: category {type: stringsql: ${TAB...
Parameter in sql table name
I am trying to parameterise my connection:view: view_name { sql_table_name: {% parameter tablename %};; parame...
ElasticSearch Data Connection
Is it possible to create a looker database connection pointing to an elasticsearch database? Specifically, is ...
Need parameter.allowed_value.label to display user attribute value, but it's not working Help please
I am setting up a parameter in a view and need the allowed_value label to display the values of a user attribu...
Show images stored in google drive folder
I’ve an AppSheet app (storage is a google sheet file) taking pictures and saving on a google drive folder. I’m...
New Filters broke parameters with type number
I've had this parameter for years: parameter: comparison_type { type: number allowed_value: { label: "Current ...
Sales of current week Vs Sales Last week based on Week Number(Custom) Selection by User
I want to show Sales of current week in a tile(Multiple value) object. Where users will be selecting a week nu...
Uisng Remote Dependency and Localization error
Hi All, I have a usecase where I am trying to use remote dependency to import a source project and reuse the c...
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...
Full outer join not work correctly
Hello, I am trying to join several views in the same explore. These views all have the same dimensions (date, ...
Filter the list of explores based on user input
As we add more and more things to our Looker environment, the list of explores increases.Not every explorer ne...
OUTER JOIN DATE DIMENSION CREATE NULL VALUE
I have two tables with no null date value. I want to union these two tables. So I decide to full outer join th...
If function not working in calculated field
Getting expression incomplete error=if((${score}>=70 AND ${score} =80 AND ${score} 90 , '20', '-5'))))If the s...
Change join on column dynamically with filters or parameters?
I have a join looks like below. As you can see one of the time filter is hardcoded in the join because I want ...
Is it possible to add custom data in context comments ?
I want to add {dashboard_id : "xyz"} to context comment -- Looker Query Context '{ "user_id":,"history_slug":,...
Filtering percentages
Hi all, I was wondering if there is a solution to filtering a metric which has a data type equal to 'percent'....
parsing json arrays coming from mongoDB in BigQuery
Parsing json and array of json is usually a pain, so I just wanted to share what I use to do this. In the foll...
Calculating % relative to Total with Multiple Filters in Different Tables
Hello, I need to use the total from one chart in another chart to calculate the % of each data point relative ...
Git lock error
We have a looker-hosted instance and noticed that Looker's Production Mode doesn't match the master branch of ...
Liquid - Number format
Hey everyone, nice to meet you all.I have a measure, which has several ifs, as it follows:measure: someMeasure...
Qualify in LookML
Hi All,I am wondering if there any way to filter on row_number window function in Looker or using LookML. I am...
Parse string to date using 'Custom Dimensions'
Hi TeamWe have a column in database that is a string format of date eg: “2022-01-19T00:00:00+00:00” and we lik...
