idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
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
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 ...
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...
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":,...
