coalesce in view with two tables
I have a requirement of doing a coalesce by joining two tables. I can do that in explore but as I need that to...
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
Reassign parameter value in LookML
How can I reassign the parameter value by selected value in filter?What I tried to do:{% assign var=_filters[‘...
declare variable in sql runner
Hi guys, I need help.I'm new to the looker, I would like to know if there is a way to declare variables in sql...
required_access_grants for extension
Hi,we have a base explore that we use as explore_source in some views and as extension for other explores. The...
GoogleJsonResponseException: API call to bigquery.jobs.query failed with error: Access Denied: Project ppc-big-query: User does not have bigquery.jobs.create permission
I’m having issues running a BigQuery function from the submit button in the sidebar. The query function works ...
Looker Implementation experience
Looking for highly technical person with Looker implementation at an Awesome company - Ciena!! Person must hav...
Table Calculations in quickstart queries
Are there any plans to allow the query parameter (for quickstarts) to contain table calculations?
Add multiple filter condition in paramater
Currently this User 1 Filter 1 Num Val filter is equating the exact value of what ever the user input in the v...
How to block comment in LookML
Hi friends,Just curious is there a way to block comment as in C we can use /*...*/?Searched the community but ...
fighting student data
How make a dashboard from fighting students data
How to integrate looker with ms team
How to integrate looker with MS team?
Looker Salesforce Data Actions
Hi everyone,I saw on a video that you can create Data Action where you can insert data in Lookers Look cell an...
Project Structure
Hi,I have a question about setting the order of the project in my instanceAll the projects are in the below fo...
Filtered minimum date measure
measure: min_this_date { type: date sql: min(${this_date}) ;; filters: [other_field: "-NULL"] }This will error...
Case When for YesNo in Custom Dimension
Hi,I need to use YesNo Dimension in Case When statement and check if it’s not equals to “Yes”, then put some v...
Changing table name in data warehouse
Hello,This might be a very basic question with a simple solution but so far I could not find it.We have a tabl...
Can I extend my view with another view, and have derived table at the same time?
Can I extend my view with another view, and have derived table at the same time?
Array column
Hi there,Would like some input on how to create a dimension from an array column in Lookml. Warm regards.
Pagination in Looker
Some old-school reporting use-cases may require viewing more than 5,000 records. Since Looker sets row limits ...
Bar chart after pivot- unexpected
Hello, I have a look that is a bar chart, this look is supposed to show 3 values, lets call them A, B, and C, ...
Empty map drill overlay modal displaying only proper drill-fields for location-type dimensions
In case anyone else is struggling with this issue, I did not see another thread or any documentation of this e...
can we specify the folder for lookml dashboard?
As a parameter in lookml dashboard code?
Passing Value from filtered measure as a label
Hello everyone, currently I am facing some usability issue with our end users.I am trying to pass the value th...
How to filter on last 7 available dates.
I am trying to filter on last 7 available dates in a dataset.For example I found this post filter-on-the-last-...
How to create link in a table column and when we click that link it should not make any change in embedded looker dashboard and shouldn't open anew tab in browser
We created one table visualization in Looker and iframe embedded in salesforce.The requirement is like when we...
How to Create Dynamic Dimension Filter
Hi,New to dynamic dimensions and measures and am having trouble solving my problem after following the other g...
Ask Looker - configuration
Hi Looker, We have added Ask Looker (from marketplace) to our Looker instance and the first step for configura...
Joining multiple views(more than 50 ) to create a single explore
Can we join more than 50 views to create a single explore?If it is possible , then do we have to write multipl...
Best way to use map layers in a project
Hi, At Holidu, we have our own definition of vacation areas in our Postgres database, using polygons, and they...
What's the alternative to NOT(contains) in View url parameter?
Seeing that there is a deprecation warning upon upgrading Looker, what is the alternative to using {% if _expl...
