Passing constants at runtime
We have a lookml which uses a constant name for a project .. lookml sql code -sel * from @project.tablejust tr...
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
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...
Limitations on number type and value_format
The Looker version we are currently on is 7.18.21Are there inherent limitations when using number and/or value...
Persist Data and Auto-Refresh
I have some slow running models and have found adding `persist_for` for 1440 minutes and scheduling the dashbo...
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...
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, ...
Get/Sync Data from Looker to Excel
I have an Excel file which I need to populate with data from Looker. The excel file is sitting in the SharePoi...
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...
Create Looker Sankey Diagram
Hi there, I’d like to create a Sankey Diagram to show flow. Data will be like page views. Users will be direct...
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 ...
Drill Downs for Table Calculations
Hi all,I have a simple table calculation on a report and I would like to control the drill down. If it was a m...
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...
