Filters narrow down the search result to only include the data you want to see.

When you add a value to your search, it becomes a filter. To add a filter from the search bar:

  1. Click in the search bar and type the values you want to include in the search.

    Typing a value in the search bar acts as a filter.

    You can also use filter keywords like yesterday, after, next month, 2016 to filter your search. To see more filter keywords, refer to the keyword reference.

  2. Click outside of the search bar or push enter to apply your filter.

Simple filters can be applied to an answer, while pinboard filters can be applied to all visualizations of a pinboard. You can find out more about pinboard filters in the pinboards section.

Where filters appear in ThoughtSpot

As you have seen with search, filters appear in white boxes in the search bar.

In an answer or a pinboard, filters appear just below the title. For pinboards, your filters apply to all worksheet-based visualizations in the pinboard.

If you ever find that your search or pinboard does not appear to contain all the data you want to see, check for any existing filters and remove them by clicking the X to see all the data.

Simple filters

Simple filters can be applied to searches in a few different ways. You can use the search bar or the Change Configuration menu to add a filter to a search. You can apply simple filters to your search, whether it shows a table or a chart. Your filters remain part of the search even when you change the visualization type.

When adding a filter from the Change Configuration menu, numeric columns and text columns provide you with a checkbox selector for values. If the column contains a date, you’ll see a calendar selector when applying a filter. This is also where you’ll go to apply bulk filters.

Bulk filters

If you have a large worksheet or table with thousands or millions of rows, you may want to create bulk filters. You can paste in a list of filter values, without having to click the box next to each value in the filter selector.

Bulk filters can be very useful when you have a very large worksheet or table. You can use them to filter a large list of values easily. For example, this is useful if you want to only search on a list of products that your manager sent to you in an email. You can cut and paste those values into the bulk filter box to quickly generate a report or chart that includes only those items of interest.

You can create a bulk filter by pasting a list of values, separated by commas, semicolons, new lines, or tabs, into the bulk filter box. This allows you to easily search a large list of filters repeatedly.