Variable to use in a Query
Hi,I would like to create or define a environment variable/s to add in a query , this variables should be get ...
Forum Posts
Advanced Date Filtering
Hello y’allI am currently trying to find my way around the advanced date filtering, and struggling to find a s...
Filter OR condition / additive result / full-custom WHERE clause
I’m looking for a way to have my Explore’s generated SQL include a WHERE clause that includes OR logic. This w...
Filter Suggest Dimension from Liquid Parameter
Hi All,I am creating a dynamic comparison tool which allows users to select a granularity to compare a selecti...
Looker Filter Suggestions not passing Parameter into Query
We’ve just started experiencing an error on the Filter Suggestions call when trying to pull up suggestions in ...
How to replicate "userelationship" (power bi) in looker?
Hi guys!The problem I’m facing is that in one fact table there are two dates:-Start date-End dateSo, in power ...
Shared filters/parameters between multiple views used in one visual
Hello,we have two views on two different fact tables joined inside one explore (not the same granularity and d...
Set default value on lookml dashboard using another filter (and its associated parameter)
I was wondering if it was possible to create a filter based on a parameter and have the parameters value be an...
Running Total by Category & Date
How can i calculate running total by category sorted by Date. I know there is option available by using runnin...
Retain Filter selection in Dashboards using temporary storage options via lookml
Hi Team ,Is there any option to save user selection on filters via look ml like a temporary storage of filter ...
Can users define group by clause in explore?
Hi, I want to create the following query in looker:SELECT _______, COUNT(*)FROM MEMBERGROUP BY _____In the cod...
Looking for a solution to count unique working days in Looker with existing parameters
Hello Looker community,I'm working on a project where I need to count the unique working days based on data in...
how to create a date filter that filters different dates in the dashboard ?
Hi, i am seeking a solution to replace the date filter in Google data studio (Looker studio), i want my create...
How to filter multiples values on a custom measure filter?
Hi, everyone!I’m trying to create a custom filter on a custom measure that uses a string column to filter a bu...
How to get filter selected minimum date and max date, and display on a table
I have a table with multiple columns, one of which is "Created_date". We also have a filter applied on "Create...
Remove (past) always_filters in looks and tiles
Is there a way that I can automatically, or at least done at once, remove filters that have been once set as a...
Find range (or Max value minus Min value) for each unique building
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Combine Multiple dimensions into single filter
Hi, I’m pretty new to Looker. I have a dataset with multiple dimensions my client wants to filter on (too many...
Date Parameter in Derived Table used in more than one way
Has anyone been able to efficiently parameterize a derived table with a date parameter such that the date is u...
How to use Or condition in dashboard filter?
How to provide Or condition between 2 dashboard filter. ------in order to resolved this I tried user custom fi...
Syntax for "less than or equal to" in templated filter
I am trying to create a templated filter that will only show data on or before a given date. i.e. a filter tha...
mesure distribution in month table (active users)
Hello guys, I have a measure that counts employees actively working in a range of time, so the measure looks a...
Total Sales for selected date filter
I need last n months sales for the brands means not separately for each months based on the number of months s...
How to set up an aggregation year filter and switch the data acquisition year for the entire dashboard at once
We would like to know if you have any ideas on how to implement the requirements in the following prerequisite...
Aggregate Awareness with filter only fields?
I have a big partitioned table which I want to add aggregate awareness to. However, it uses a filter only fiel...
Load filter suggestions for dynamic sql_table_name
Hello All,I have a scenario where I need to pick a database/schema for a table based on a user selectionbelow ...
malformed SQL for specific filter char
(i use snowflake)sequser sets filter as "contains" and puts 'test$%^23' (without quotes) then sql contains a s...
Can we use liquid parameters in string filter field to assign dimension values to be used as dynamic filters
Hello,I came across one use case where I had to assign multiple filters based on a specific value of a dimensi...
Can we restrict filter condition options for strings?
Hi,I have a filter for string type and in the dropdown it shows the options based on which we can filter, Can ...
LookML error happens when switch to new LookML runtime
When I apply new_lookml_runtime: yes in the manifest.lkml, a LookML Error appears. The error message is someth...