Searching in ThoughtSpot
Use search to answer questions about your data without having to consult a data analyst.
Using ThoughtSpot’s relational search is simple, so anyone can use it.
In the search bar, type what you are interested in exploring, for example
revenue midwest sales rep.
Searches return a set of results in the form of a table or a chart.
ThoughtSpot likes to call this set of results in response to a search an answer.
As you get better with ThoughtSpot’s search, you will be able to get more out of your data by performing more complex searches. There are a few basic things you should understand before starting a new ThoughtSpot search.
You’ve probably seen one of these before:
Click in the box and start typing some letters. As soon as you begin typing, ThoughtSpot suggests some search terms. Type slowly and use the suggestions to find what you’re looking for.
After you press Enter on your keyboard, or select Go to the right of the search bar, you can see an answer in the form of a chart or a table.
You should know that search in ThoughtSpot is more like an Amazon search than a conversation. For example. Instead of:
Find me all books by Lewis Carroll with the title Alice in Wonderland
Or consider Google. You wouldn’t type in:
Find me the largest city by population
largest city by population
largest city population
That’s how search works in ThoughtSpot. You can use some helping words like “by” and “for” but they can also be left out, and the search will return the same answer.
Search is based on the tables that exist in your data. Tables are made of rows and columns, like spreadsheets. So you can search by typing in any of these words:
The column name: like revenue, product name, or store
Any of the values in the columns: like 20000, kitten chow, or richmond
One of the special keywords ThoughtSpot understands: like yesterday, >, or contains
An answer is the result of a single search. You can save an answer you want to work more on later, or just keep it for your personal use. You can also share an answer with other users. The Answers tab is where you can view and then edit your saved search results.