Interval notation for filtering numbers

  • 25 February 2019
  • 2 replies

Hey there,

I am trying use interval notation in a custom filter. For some reason its not working as i expected it to… Please guide me on this.

Here is a simple expression i am trying.


As per the document, it is supposed to find 1 < fact.hour < 2

The expression editor says its an incomplete expression.

2 replies

Userlevel 3


This syntax is used for ‘matches (advanced)’ style filtering, here’s what it says at the top of the page:

Filter expressions are an advanced way to filter Looker queries, and this page describes how to write them. In the Explore section of Looker you can use them by adding a filter and choosing the matches (advanced) option. They are also used in LookML for elements that take a filter parameter

Here’s a screenshot to show where to use it:


Here’s a link to the syntax for custom filters (and table calcs)



Userlevel 3

Hey @Girish_G! You can definitely use matches filters in custom filters! Take a look here for the syntax for the matches_filter() function you’ll need to use in your custom filter.