Use keywords to help define a search.
You can use keywords when asking a question to help define your search. This reference lists the various keywords.
Keywords in Other Languages
Currently, we offer the following keyword translations.
日本語 | 中文 (简体) | Deutsch | Español (Latinoamérica) | Español (España) |
Français (Canada) | Français (France) | Português (Brasil) | Português (Portugal) | Italiano |
Dansk | Suomi | Svenska | Norsk | Nederland |
Also, see the topic on how to set locale preferences in your user profile to control language, date, and number formats on the ThoughtSpot UI.
General
Keyword | Examples |
---|---|
top n |
|
bottom n |
|
sort by |
|
Note: When using the top or bottom keywords without specifying a number (n), the number defaults to 10.
Date
Keyword | Examples |
---|---|
after | order date after 10/31/2014 |
before | order date before 03/01/2014 |
between … and ... | order date between 01/30/2012 and 01/30/2014 |
daily | shipments by region daily |
day | count monday restaurant |
day of week | revenue by day of week last 6 months |
day of week | count shipments Monday |
week | revenue by week last quarter |
weekly | revenue weekly |
month year | commission by sales rep February 2014 |
month | commission January |
month | revenue by month last year |
monthly | commission > 10000 monthly |
quarterly | sales quarterly for each product |
year | revenue by product 2014 product name contains snowboard |
yearly | shipments by product yearly |
week to date | sales by order date week to date for pro-ski200 |
month to date | sales by product month to date sales > 2400 |
quarter to date | sales by product quarter to date for top 10 products by sales |
year to date | sales by product year to date |
last n hours for each day | sales last 2 hours for each day |
last n days for each week | total sold last 2 days for each week |
last n days for each month | sales last 2 days for each month |
last n days for each quarter | revenue last 15 days for each quarter |
last n days for each year | revenue last 300 days for each year |
next n days for each week | opportunities next 2 days for each week |
next n days for each month | opportunities next 2 days for each month |
next n days for each quarter | opportunities next 15 days for each quarter |
next n days for each year | opportunities next 300 days for each year |
last n weeks for each month | sales last 3 weeks for each month |
last n weeks for each quarter | sales last 2 weeks for each quarter |
last n weeks for each year | sales last 3 weeks for each year |
next n weeks for each month | meetings next 3 weeks for each month |
next n weeks for each quarter | meetings next 2 weeks for each quarter |
next n weeks for each year | meetings next 3 weeks for each year |
last n months for each quarter | cost last 2 months for each quarter |
last n months for each year | cost last 8 months for each year |
next n months for each quarter | projected cost next 2 months for each quarter |
next n months for each year | projected cost next 8 months for each year |
last n quarters for each year | sales last 2 quarters for each year |
next n quarters for each year | projected sales next 2 quarters for each year |
daily year-over-year | growth of revenue by order date daily year-over-year |
weekly year-over-year | growth of revenue by date shipped weekly year-over-year |
monthly year-over-year | growth of revenue by receipt date monthly year-over-year |
quarterly year-over-year | growth of revenue by date shipped quarterly year-over-year |
growth of … by … daily | growth of sales by order date daily |
growth of … by … weekly | growth of sales by receipt date weekly for pro-ski2000 |
growth of … by … monthly | growth of sales by date shipped monthly sales > 24000 |
growth of … by … quarterly | growth of sales by date shipped quarterly |
growth of … by … yearly | growth of sales by date closed yearly |
growth of … by ... | growth of sales by order date |
last n days | visitors last 7 days |
last n weeks | visitors last 10 weeks by day |
last n months | visitors last 10 months by day |
last n quarters | visitors last 2 quarters by month by campaign |
last n years | visitors last 5 years by revenue for sum revenue > 5000 |
last week | customers last week by store |
last month | customers last month by store |
last quarter | customers last quarter sale > 300 |
last year | top 10 customers last year by sale by store for region west |
n days ago | sales 2 days ago |
n weeks ago | sales 4 weeks ago by store |
n months ago | sales 2 months ago by region |
n quarters ago | sales 4 quarters ago by product name contains deluxe |
n years ago | sales 5 years ago by store for region west |
this day | shipments this day by order |
this week | shipments this week by store |
this month | appointments this month by day |
this quarter | opportunities this quarter amount > 30000 |
this year | opportunities this year by sales rep |
next n days | shipments next 7 days |
next n weeks | shipments next 10 weeks by day |
next n months | openings next 6 months location |
next n quarters | opportunities next 2 quarters by campaign |
next n years | opportunities next 5 years by revenue |
next day | shipments next day by order |
next week | shipments next week by store |
next month | appointments next month by day |
next quarter | opportunities next quarter amount > 30000 |
next year | opportunities next year by sales rep |
today | sales today by store |
yesterday | sales yesterday for pro-ski200 by store |
Time
Keyword | Examples |
---|---|
detailed |
ship time detailed
|
hourly |
visitors by page name hourly
|
last minute |
count homepage views last minute
|
last hour |
count unique visits last hour
|
last n minutes |
count visitors last 30 minutes
|
last n hours |
count visitors last 12 hours
|
next n minutes |
count visitors next 30 minutes
|
next n hours |
count visitors next 12 hours
|
this minute |
count visitors this minute
|
this hour |
count visitors this hour
|
n minutes ago |
sum inventory by product 10 minutes ago
|
n hours ago |
sum inventory by product by store 2 hours ago
|
Text
Keyword | Examples |
---|---|
begins with |
product name begins with 'pro'
|
contains |
product name contains "alpine" description contains "snow shoe"
|
ends with |
product name ends with 'deluxe'
|
not begins with |
product name not begins with "tom's"
|
not contains |
product color not contains 'tan' product color not contains 'red'
|
not ends with |
product name not ends with "trial"
|
similar to |
course name similar to 'hand'
|
not similar to |
course name not similar to 'hand'
|
Number
Function | Examples |
---|---|
sum |
sum revenue
|
average |
average revenue by store
|
count |
count visitors by site
|
max |
max sales by visitor by site
|
min |
min revenue by store by campaign for cost > 5000
|
standard deviation |
standard deviation revenue by product by month for date after
10/31/2010
|
unique count |
unique count visitor by product page last week
|
variance |
variance sale amount by visitor by product for last year
|
Comparative
Function | Examples |
---|---|
all | all |
between... and |
revenue between 0 and 1000
|
vs, versus |
revenue east vs west
|
> |
sum sale amount by visitor by product for last year sale amount > 2000
|
< |
unique count visitor by product by store for sale amount < 20
|
>= |
count calls by employee lastname >= m
|
<= |
count shipments by city latitude <= 0
|
= |
unique count visitor by store purchased products = 3 for last 5
days
|
!= |
sum sale amount region != canada region != mexico
|
Period
Keyword | Example |
---|---|
quarter (date) | quarter (purchase date) |
quarter of year (date) | quarter of year (purchase date) |
month of quarter (date) | month of quarter (purchase date) |
week of year (date) | week of year (ship date) |
week of quarter (date) | week of quarter (ship date) |
week of month (date) | week of month (ship date) |
day of year (date) | day of year (ship date) |
day of quarter (date) | day of quarter (ship date) |
day (date) | day (ship date) |
day of month (date) | day of month (order date) |
day of week (date) | day of week (order date) |
hour (datetime) | hour (timestamp) |
In
Keyword | Example |
---|---|
attribute in (attribute subsearch) | store name in (top 10 store name by sales footwear) Must match last attribute before keyword with first attribute inside subsearch. |