Dashboard and Look versioning
Is there any way to use version control in Dashboards and Looks with Github?I'm facing a challenge of maintain...
Forum Posts
Can I use a user_attribute for a filter title on LookML dashboard?
hello, I have a customizable dimension label based on a user attribute and I am having trouble using that valu...
Value format in looker. We are trying to break number in billiion, million and thousands dynamically
Folks,We are trying to format numbers in Looker dynamically in billions, million, and thousands dynamically. B...
Add Group Header Rows
Hello Looker Community!I was wondering if there is a way to add a group header row in looker. What I mean by t...
dynamically select dashboard time period with parameter
Hello, I want my users to use a "filter" (parameter) to select the time period of the dashboard, e.g. date, we...
How do I change a model/explore for a Dashboard
Hey all,I have built a dashboard under project A ( model name: A) and now we have a new project B with a new m...
dynamic hyperlink
Hi, is it possible to create a dynamic hyperlink that opens a new report and updates two different data sourc...
Having different hidden states for the same dimension in different explores
Hi there,I am trying to 'hide' (hidden: yes) a dimension in one explore, but have it visible in another.I am a...
Liquid variable
Can i use this logic in a liquid variable in an explore?{% if table1name.dimension._in_query and table2.dimens...
Dynamic date range filters in PostgreSQL
Hello everyone!We are implementing Looker with a warehouse in PostgreSQL, we have some Facts partitioned by da...
Full Outer Join Primary Key Issue
Hi,I would appreciate any help related to the following situation. I have 3 views:Users - Unique table of user...
Dynamically changing looker connection inside model file
I have been trying to dynamically change the looker connection using user attributes. Here the database connec...
Arrays from clickhouse to Looker
Hi there,I understand that array types stored in clickhouse can not be retrieved in Looker unless converted to...
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...
Building a Flexible LookML Model
Hi everyone,I'm seeking guidance on creating a LookML model that empowers end users to construct dashboards wi...
Dynamic number of occurrences of weekday calculation
Hi,I have a bunch of call centre data that I'm working with. One of the things I want to do it be able to calc...
Passing user input date to where clause filter to the resultset
Dear all,I would like to get your thoughts on the below scenario.I have a table with a reporting date as a col...
Dynamic Parameter for Dashboard Tile?
I am trying to build a tile for a dashboard that inherits a region dimension from the filter.Basically, the ti...
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...
Filter Max Date by different timeframes
Hi! I have an unusual use case that i would like to resolve. I have a BigQuery table that has information week...
I am looking to create a Calendar
i wanna create a calendar con i can visualize the time off of my employees, is it posible on looker?in a calen...
Looker
format_datetime('%b-%y',current_date()) how write above one in liquid parameters
Error: Creating an NDT with bind_all_filters on an explore which is extended
Hi all,We need to create a dynamic top N ranking on a dimension and we feel like creating an NDT with bind_all...
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...
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...
Refinement
im having problem with my Refinement view.if explore using my view sit in different model then it will use the...
Is it possible to assign date_start to a liquid variable
Please see my reply comment left in this thread . I am basically trying to do exactly what OP did by using liq...
How to PoP
https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Methods-for-Period-Over-Period-PoP-Analysis-in-L...
How to make NULL (∅) values zero within a dynamic field.
Hello, I am new to looker. This code is for a tile in my dashboard and I want it to show '0', when there are n...
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...