REPLACE Characters in string filters
Knowledge DropLast tested: Jul 30, 2019 If you see odd results in a drill's filter string, it may be that the ...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
How to use access filters in derived tables
Knowledge DropLast tested: Oct 31, 2019 QuestionHow do I use access filters inside the SQL of a derived table?...
Custom Filters: 1 complete month ago
Knowledge DropLast tested: Feb 2, 2021 ${events.created_date} >= add_months(-1,trunc_months(now()))AND ${event...
How to pass a filter condition to a derived table AND keep it in the main query
Knowledge DropLast tested: March 2021The ProblemI need a condition to appear in the WHERE clause of my derived...
How do Filter Suggestions Work?
Knowledge DropLast tested: Aug 21, 2020 Filter suggestions are a way to save time when typing into filters and...
Automagic heatmap creates a "binning resolution" filter
Knowledge DropLast tested: Dec 11, 2017 If you come across an unexpected bin filter on an automagic heatmaps, ...
How can I enter multiple filters into Parameters?
Knowledge DropLast tested: May 2020Parameters only accept a single value.In the event that you have a comma se...
Pass an external value to an embed URL as a filter
Knowledge DropLast tested: Jul 17, 2020 Say you have a php script which is storing the value when a user visit...
How do I apply one filter to multiple fields?
The Use Case: Say you want to have a single filter apply to two separate fields (fields A and B). The end goal...
Why does it show the faceted filter icon even though there aren't any faceted filters enabled?
The problem:Sometimes, you can encounter a situation where you see the faceted filters icon even though there ...
How do I filter results in my visualization, without filtering out rows in the data tab?
The Problem:I have a use case where I need to filter out rows in my visualization, but need all the rows to re...
How to apply access_filters to views
Knowledge DropLast tested: May 6, 2020The ProblemI have an access_filter for one of my explores. But I'd like ...
Why isn't my liquid variable passing values into my URL filter correctly?
Knowledge DropLast Tested: Jan 29, 2020There are two main reasons that this happens:The values are not url-enc...
How can I have a 'label' field and a 'value' field for suggestions?
Knowledge DropLast tested: Jun 1, 2020 This is a feature request: For suggest filters, have a 'label' field an...
Setting up an access_filter that applies to only specific users
Knowledge DropLast tested: Mar 27, 2019 Every user who accesses an Explore that has an access_filter must have...
What is the matches (advanced) filter expression syntax for not applying a filter at all?
Knowledge DropLast tested; May 12, 2020 0 OR NULL for numbers, %,NULL for strings.To get all non-null values, ...
Weekly Rollup Calculation
Knowledge DropLast tested: Mar 17, 2020 Like many people out there, you like to automate processes and cringe ...
How do access_filter, sql_always_where, full_suggestions, and bypass_suggest_restrictions work with filter suggestions?
Knowledge DropLast tested: Sep 1, 2020 To understand how these parameters interact with filter suggestions, it...
Week to Date over Week to Date Analysis
Knowledge DropLast tested: Mar 25, 2020 Context: Pretty specific use case here, as the user wanted a way to co...
Use dimension type: duration to create a filter denominator
Knowledge DropLast tested: Nov 29, 2018 If we are looking for a way to take the value of a date filter and use...
Does extends override a parameter if the same parameter is defined in both the original and extending version?
Knowledge DropLast tested: Sep 13, 2018 If a LookML object is explicitly defined in both places, then the obje...
Why are my explore filters not getting added when I drill down on a measure?
Knowledge DropLast tested: Sep 15, 2019 It is most likely because the measure may have filter defined, i.e it ...
What purpose does the `sql:` clause in a Templated Filter serve?
Knowledge DropLast tested: Nov 23, 2018 The sql: clause in a Templated Filter gets injected directly into the ...
"This filter contains an error and won't be included in the query"
Knowledge DropLast tested: Aug 14, 2018 This warning message comes up when there is a character mismatch betwe...
Hide Filters on Embedded Dashboard
Knowledge DropLast tested: Jun 17, 2020 When you hide filters (Un-toggle show filters) on an embedded dashboar...
Custom filter for this month vs the same days of last month.
Knowledge DropLast tested: Feb 4, 2021extract_days(${query.created_date}) <= extract_days(now()) AND diff_mont...
Why are my drills on running_total showing only that row?
Knowledge DropLast tested: Aug 6, 2020 running_totals are post-generated after the query is run, and so when w...
How do I update filters on a Look with the API?
Knowledge DropLast tested: Sep 17, 2020 Get the existing query using the look endpoint Create a new query with...
Alias in filter suggestions
Knowledge DropLast tested: Apr 30, 2020 If you're using an ID, you may want to use a more human-friendly sugge...
How to filter on the last day with available data
Knowledge DropLast tested: Jun 5, 2020 Create a yesno dimension like this:dimension: latest_date { type: yesno...
