Dynamics icon_url
Hi, is it possible to create a dynamic iron_url?I’m using the link parameter and for the icon_url I wanted 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
Yesno for data
Dear Colleagues, I have a question.I have column with string. I do like this:dimension: main_table_boolean { t...
Sending list to marketo - Error Multiple lead match lookup criteria
Hello I’m using tags for sending list to Marketo. It works for almost all records but for some records I have ...
adjustment week of week
Hi,I want to display data week by week of this year, and I have data on 2021-01-01 and it belongs to week 53. ...
Display only values with the latest date by State
My data is formatted like so:State, weather, dtCalifornia, sunny, 9/23/21California, rainy, 2/22/20California,...
Queries running endlessly and not fetching results
Hi,Has anyone faced an issue with the queries getting queued and running endlessly without loading any results...
Percent of Total from Database
Hi, I’m trying to get the percentage of total revenue by each of the top 10 Brands (dimension).The logic would...
SQL Server connection Error
Hi Team,I am new to Looker and when I am getting below error when I try to establish connection with the On pr...
how to add pagination to dashboard
How to create pagination in lookmlcode
Filter suggests generate different queries in production mode
We have a filter on a virtual field (an unnested column).This works in development mode and generates the foll...
install looker
how to install looker can we let know step by step
Skip cross-filter
It would be helpful if we could have something like skip_drill_filter for cross-filtering. There are some use ...
Function LAST
Hello,Do we have any “LAST” function? The following query is not working, and I want to extract the last limit...
Conditional where
Hello, im having trouble with my code in the 6th line. I already tried “BETWEEN 0 AND 5000” and this. Does som...
Using liquid parameters to filter multiple values
This is a two part question - Is there a way to use a parameter field to allow for filtering multiple values? ...
Complete dynamic date filter
Hi,I am currently working on a marketing dashboard, where the business user will be able to dynamically aggreg...
Could not find a declaration file for module 'readable-stream'.
Could not find a declaration file for module 'readable-stream'. I changed my typescript version then I saw thi...
Basic Case Statement
I’m having difficulty getting a seemingly simple case statement to work. Getting the following error when runn...
Extending multiple explores at the same time
I haven’t been able to find an example of this? The documentation only seems to say it is possible, but doesn’...
How do I grant my user access to an explore?
Hi! I am a bit rusty with Looker so I have a question.I have imported a view from my database and created a mo...
Inverse or exclud access grants
We have a model with lets say 10 explores.There is a lot of content built on all these explores already.There ...
LookML Diagram
The base view is not the one highlighted in dark blue in the LookML Diagram for one of my explores. Not sure w...
How to select a particular columns based on a filter in Derived table
How to select a particular columns based on a filter in Derived tableeg. select a,b from tablefilter values (b...
Explore doesn't appear under Explore menu
New to Looker.I created a project, then created a model and a view.I then created an explore based on the view...
Creating a new column
Is there a way to create a new column based on the values of another column? In another viz tool, I could use ...
Is it possible to return dimensions with different types under a single parameter?
Hi all, Now I have the data which is similar as follows:week_from_launch date sales 52 2020-08-15 1000104 2021...
Can I localize and import in my looker project?
Hi guys, hope you are doing well. Recently, I was trying to add localization_settings to my project’s manifest...
Educator plan
Hello,I am a teacher in a French university.I want to give the Looker course how do I get an academic license ...
Best practice for restricting data
New to looker. I’m looking for the best way to restrict data based on domain/tenants. Obviously someone in Ten...
Value_format to remove trailing dot
dimension: value_num { type: number value_format: "0.##" sql:CAST (${value_string} AS FLOAT64) ;; }The result ...
