Looker
format_datetime('%b-%y',current_date()) how write above one in liquid parameters
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
Link a Dashboard to another one passing values
Hi all!I have a dashboard with some information on a grid (Project info); my goal is to click on a value in a ...
Tooltip clipped
I have a dimension with a link and an html tag to add a tooltip as follows. dimension: price { type: number va...
Keyword Labeling
Hi! I want to label Google Search Console keywords in Google Looker Studio. I tried doing to do so using a CAS...
Doubt with conditional filter
Hello everyoneNew with Looker and following some of the Labs available. In one of them we need to create a con...
Open dimension URL in a popup window
I would like to be able to render html inside a popup windowHere is my dimension:dimension: view_HTML { sql: '...
Advanced Date Filtering
Hello y’allI am currently trying to find my way around the advanced date filtering, and struggling to find a s...
Pass date filter using liquid variables in html
Hello… hoping you can advise. I’m trying to pass multiple dashboard filters including a “date range” filter to...
How to define environment variable in Looker
I have looker project which needs to be deployed in Dev, QA & Prod. I need to define environment specific cons...
Dynamic Timeframe option
I need to create a custom option in the timeframes drop down menu that will vary depending on the user. For ex...
Percentage change between two rows in a table
Hello! I have been trying for several days to make a table whose columns are some metrics such as impressions,...
"include: references a project not in the manifest"
Hi thereI am doing a big cleanup in our Looker project. After a lot of deleting, I’m getting tons of errors wi...
Dashboard Button link to get filter values and auto-apply in Look
Could you help me with one tricky functionality I am trying to implement in Looker.Let me provide the backgrou...
How can use matches(advanced) in looker to filer records last 30 days before the recent Monday
I'm working on a Looker dashboard, and I need to filter records based on a date dimension for the last 30 days...
How can I filter records “ before Monday for 30 days”?
We have a date dimension and we want to filter using matches(advanced) the last 30 days before the recent Mond...
Looker Over Complex Queries
Hi, I'm having an issue right now in looker where I have an explore based on one table let's just call it "amo...
Liquid: number_with_delimiter not working
Hi, am new to Looker and I am trying to use liquid for some advanced conditional formating but it seems to me ...
Dynamic Fiscal Year Offset
We are using Looker embedded in our app to service multiple clients. Though most clients' use a calendar year,...
Uniqueness test generates wrong SQL with count(distinct)
I have a model, where videos is main table, with playbacks joined to it. Each playback has playback_key (set a...
liquid condition / endcondition / _is_filtered when using AND/OR filters
Until the Feb 2024 release of Looker, it was possible to use the liquid {% condition dimension_name %} dimensi...
Difficulty Formatting Percentage Values in Looker Visualizations
Hello,I'm encountering an issue with percentage formatting in Looker visualizations. I have defined a measure ...
order_by_field descending?
Is there a way to use the order_by_field parameter in my dimension, but specify that it should sort Descending...
How to convert number to time in looker
Hello Team,I am query regarding how to convert measure with number data type to time data type in the form of ...
Google Looker actions
I'm attempting to create a dimension based on the value generated by a HTTP request. After some research, it s...
Date Dimension with Global Holiday Calendar
Hi,I need data about all holidays and days off in world.I'd like to get example script for all tables
liquid with drill_fields
Hi, Im trying to achieve something along the lines of the following. I want to display a different set of deta...
New LookML breaks cell HTML colour format
Problem: in 19 days, a Looker upgrade will be performed in my instance, and the HTML/Liquid rendering for heat...
Show custom message for empty resultset
When there is empty resultset for the looks in the dashboard, how to show a custom message instead of "No resu...
Download PDF reports limits the rows
When downloading a report as .pdf, we select download and it does download only what’s visible in the UI. it d...
Automatically create Lookml Views, Model, Explores
Hi, I was wondering if it is possible to create Look-ml views, model, explores automatically. Somethin like wh...
