Skip to main content

Filter Bar

A closer look at how to use the Filter Bar

Greg Olsen avatar
Written by Greg Olsen
Updated today

Filter Bar

A closer look at how to use the Filter Bar

The Filter Bar allows you to filter your data in complex ways, depending on your Data Type. These filters can include the following operators:

  • Is (=)

  • Is not (≠)

  • Exists

  • Does not exist

  • Is less than (<)

  • Is less than or equal to (≤)

  • Is greater than (>)

  • Is greater than or equal to (≥)

  • Is between inclusive-inclusive (≤≥)

  • is not between inclusive-inclusive (≤/≥)

These options give users more flexibility to drill down into data in a meaningful way.

Filter Relationships

Two separate filters added to the filter bar have an “AND” relationship. Values from within the same filter have an “OR” relationship.

In the example below, the City and Crash Severity filters are separate filters, so they have an AND relationship. This means the query will return crashes that occurred in Salt Lake City AND have the specified crash severity(s).

On the other hand, the values selected within the Crash Severity filter—Suspected Serious Injury and Fatal—are from the same filter and therefore have an OR relationship. Therefore, the query will return crashes that occurred in Salt Lake City AND had a crash severity of Suspected Serious Injury OR Fatal.

Using the Filter Bar

1. Click on the filter bar. A list of all searchable columns will immediately appear. If you are looking for a specific value, start typing it in to narrow down the column list.

2. Click on the column name you wish to search by.

3. Choose the appropriate operator (IS, IS NOT, etc) for the filter you would like to apply (Note: you will not always be prompted to select the operator; when selecting text fields, the operator will automatically be set to “=”).

4. Select from the available values in the filter bar and choose multiple options if applicable to your query.

5. Select “Apply” or press “Enter” on your keyboard to apply filters.

6. To remove a single filter, click on the X button next to it in the filter bar. To remove all filters, click on the X button on the far right side of the filter bar.

Each Data Type, along with the associated search capabilities and examples of how to use them are provided below:

Text

Filter by IS and IS NOT.

Example: Country is Spain. City is not Madrid.

Integer & Decimal & Currency

Filter by IS, IS NOT, IS LESS THAN, IS LESS THAN OR EQUAL TO, IS GREATER THAN, IS GREATER THAN OR EQUAL TO, IS BETWEEN, IS NOT BETWEEN.

Example: Order Number is between 1005 and 1010.

Date & Time

Filter by IS LESS THAN OR EQUAL TO, IS GREATER THAN OR EQUAL TO, IS BETWEEN, IS NOT BETWEEN.

Day & Time fields also allow you to search by Hour of Day, Day or Week, and Month of Year.

Example: Order Date between 11/18/2018 - 11/30/2018.

Example: Order Dates on Wednesdays.

True/False (Boolean)

Filter by IS and IS NOT.

Example: “Is Shipped Order” column is 1 (True).

Geo Shape (Geocoordinate Boundaries)

Filter crashes by lat/long boundary coordinates.

Example: Only show Crashes within defined City limits.

Currently only available for Transportation applications.

Did this answer your question?