Hi,I would like to create or define a environment variable/s to add in a query , this variables should be get ...
Hello y’allI am currently trying to find my way around the advanced date filtering, and struggling to find a s...
I’m looking for a way to have my Explore’s generated SQL include a WHERE clause that includes OR logic. This w...
Hi All,I am creating a dynamic comparison tool which allows users to select a granularity to compare a selecti...
We’ve just started experiencing an error on the Filter Suggestions call when trying to pull up suggestions in ...
Hi guys!The problem I’m facing is that in one fact table there are two dates:-Start date-End dateSo, in power ...
Hello,we have two views on two different fact tables joined inside one explore (not the same granularity and d...
I was wondering if it was possible to create a filter based on a parameter and have the parameters value be an...
How can i calculate running total by category sorted by Date. I know there is option available by using runnin...
Hi Team ,Is there any option to save user selection on filters via look ml like a temporary storage of filter ...
Hi, I want to create the following query in looker:SELECT _______, COUNT(*)FROM MEMBERGROUP BY _____In the cod...
Hello Looker community,I'm working on a project where I need to count the unique working days based on data in...
Hi, i am seeking a solution to replace the date filter in Google data studio (Looker studio), i want my create...
Hi, everyone!I’m trying to create a custom filter on a custom measure that uses a string column to filter a bu...
I have a table with multiple columns, one of which is "Created_date". We also have a filter applied on "Create...
Is there a way that I can automatically, or at least done at once, remove filters that have been once set as a...
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Hi, I’m pretty new to Looker. I have a dataset with multiple dimensions my client wants to filter on (too many...
Has anyone been able to efficiently parameterize a derived table with a date parameter such that the date is u...
How to provide Or condition between 2 dashboard filter. ------in order to resolved this I tried user custom fi...
I am trying to create a templated filter that will only show data on or before a given date. i.e. a filter tha...
Hello guys, I have a measure that counts employees actively working in a range of time, so the measure looks a...
I need last n months sales for the brands means not separately for each months based on the number of months s...
We would like to know if you have any ideas on how to implement the requirements in the following prerequisite...
I have a big partitioned table which I want to add aggregate awareness to. However, it uses a filter only fiel...
Hello All,I have a scenario where I need to pick a database/schema for a table based on a user selectionbelow ...
(i use snowflake)sequser sets filter as "contains" and puts 'test$%^23' (without quotes) then sql contains a s...
Hello,I came across one use case where I had to assign multiple filters based on a specific value of a dimensi...
Hi,I have a filter for string type and in the dropdown it shows the options based on which we can filter, Can ...
When I apply new_lookml_runtime: yes in the manifest.lkml, a LookML Error appears. The error message is someth...