Adding a custom dynamic filter to LookML dervied table
I need to add a dynamic filter to a view so I would only have to change the filter when changing the parameter...
Forum Posts
Hierarchy of User Attributes and Access Filters to access more or less in dashboards off 1 Explore
Hello,I need help trying to approach accessing different user attribute data across dashboards for a single ex...
I am new to the Looker, Please help me to filter timeframe measures with wtd , ptd, std and ytd.
In addition to the topic I am looking like I run a LookML for any given date the measures wtd, ptd, std and yt...
Dinamic URL - fitler name switches to special character
Hi!Scenario:have a dashboard that have links to another dashboards and I want to persist filtering between the...
join based on multiple conditions
I am trying to join 2 tables in the explore using sql_on.The first condition is ON and the second condition, I...
Dim Date table to another table How to create relationship? b/w two tables?
Hi Team,i have a 2 tables called product and dim_date.now i have to create relationship b/w the two tables usi...
How to use like with a templated filter
I’d like to do something like this: select * FROM table where {% condition topic %} ILIKE title {% endconditio...
Why is my Explore insisting on a datetime for the filter?
Hi,I have an underlying database table where the field type is date, and then in the view I had it set as date...
Dynamic Period-over-Period Filter Comparison
Hi,Sorry if my English is not the best.I’m working with a client who needs to realize a dynamic comparissons o...
method 3: period on period comparisons using postgres SQL
Hi, I have found this article which helps with period on period comparisons however it is in big query and I w...
Dynamic dates based on Completed period and period to date
Hi all, I was wondering if anyone has set up / knows how to do dynamic dates that are able to filter for day l...
templated filters and derived tables
view: closed_loans { derived_table: { sql: with closed_loan_data as ( select row_number() over (order by coale...
Multiple selection dropdown menu with a SQL DISTINCT UNION of values
Hello,I’d like to create a dropdown filter of approximately 70 values, the values are from an SQL query of the...
LookML filter dependent on another?
Hello, I am trying to create two filters on a dashboard. The setup is this. We have multiple teams and multipl...
Compare Current Day with the last 7 days average
HiI’m trying to build a look/table which shows a measure for current day value, as well as an average of the l...
LookML Dashboard: Restricting values in dropdown filter
Hello I am creating a LookML dashboard and currently I have a field_filter which allows the user to choose fro...
FIiter an explore before join
Hello, so I have two problems.PROBLEM1So, I have this explore and join in a model. I want to join some values ...
Split aggregation for a filter in LookML
Is it possble to use something similiar to string_split in LookML to get unique value for my filters?I have a ...
Creating a measure for same day last month
Hi folks, I’m looking to build a measure to sum a number e.g. outstanding balance for the same day last month....
Looker Filter Expressions
Hi Community!What are the differences between measures leveraging Looker Filter Expressions and When Case Stat...
How to set a relative date as the default date for a date filter parameter?
How to set default value for a date filter parameter which is like ‘3 months before todays date’ and also give...
Conditionally multiplying a numeric filter
We have an implementation of Period-over-Period analysis that we’ve paired with a date granularity filter so t...
Row Level Security with Explores & SQL "Injected" Dimensions
We currently use user attributes to filter out other clients information in our Looker dashboards. Originally,...
LookML Filter Field does not filter null values
In my looker instance, there is a filter only field defined in the LookML (called “feedback_selection_filter”)...
Custom filter on measure
I have created a parameter using allowed values and a certain range of percentages to select: parameter: param...
Creating a custom dimension cohorting users
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
How to filter for two weeks ago
I have a column that shows sales and I have a column that shows sales date. I am trying to create a filter tha...
cancel group by in measure
Can i cancel group by for measure instead of whole explore?
How to set filter_config as range of date in sdk.run_inline_query
I try to set date range though sdk.run_inline_query. I guess I need to set the filter_config for date range an...
Errors with Setting Default Time Filters
I have an application where I want users to be able to filter their data by time on a dashboard, and I want to...