Skip to content
On this page

Filters

Filters are a way to narrow down the data that is displayed in the query result. They are a great way to focus on a specific subset of data. You can add Simple as well as Complex filters to your query.

Simple Filters

Simple filters are used to filter data based on a single dimension or metric. You can add a simple filter by clicking the + button in the filters section.

Joins

Following are the available operators:

  • equals - Checks if the column value is equal to the value.
  • not equals - Checks if the column value is not equal to the value.
  • greater than - Checks if the column value is greater than the value.
  • greater than equal to - Checks if the column value is greater than or equal to the value.
  • less than - Checks if the column value is less than the value.
  • less than equal to - Checks if the column value is less than or equal to the value.
  • is - Checks if the column value is set or not.
  • one of - Checks if the column value is in the list.
  • not one of - Checks if the column value is not in the list.
  • between - Checks if the column value is between the two values.
  • within - Checks if the column value is within the time range.

Expression Filters

Expression filters are used to filter data based on a complex expression. You can add an expression filter by switching to the Expression tab in the filters section.

Joins

You can see the available functions and operators in the Expressions section.

Released under the MIT License.