Question

Interval notation for filtering numbers

  • 25 February 2019
  • 2 replies
  • 73 views

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.

${fact.hour}(1,2)

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

Hi,


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:

image


Here’s a link to the syntax for custom filters (and table calcs) https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators


Best,

Andy

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.

Reply