Keyword reference

You can use keywords when asking a question to help define your search. This reference lists the various keywords. You can also see this list of keywords and examples from within the help center.

Keywords in other languages

Currently, we offer the following keyword translations.

Dansk

Deutsch

Español (España)

Español (Latinoamérica)

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 Description Examples

Keyword	Description	Examples
top n	Generates the top n from a sorted result	`top 10` sales rep revenue `top` sales rep by count sales for average revenue > 10000 sales rep average revenue for each region `top`
top n measure1 by attribute\|measure2	Calculates top n, then sorts the top items by another measure or attribute. Contrast with top n (swaps the order of operations)	`top 10` sales rep revenue by profit margin
bottom n	Generates the bottom n from a sorted result	bottom 25 customer by revenue for each sales rep bottom revenue average bottom revenue by state customer by revenue for each sales rep bottom
sort by	Sorts the result set by an attribute or measure.	revenue by state sort by average revenue revenue by customer sort by region
by measure	Treats the measure as an attribute and groups the result set by it.	cost by revenue product by quantity purchased

top n

Generates the top n from a sorted result

top 10 sales rep revenue
top sales rep by count sales for average revenue > 10000
sales rep average revenue for each region top

top n measure1 by attribute|measure2

Calculates top n, then sorts the top items by another measure or attribute. Contrast with top n (swaps the order of operations)

top 10 sales rep revenue by profit margin

bottom n

Generates the bottom n from a sorted result

bottom 25 customer by revenue for each sales rep bottom revenue average
bottom revenue by state
customer by revenue for each sales rep bottom

sort by

Sorts the result set by an attribute or measure.

revenue by state sort by average revenue
revenue by customer sort by region

by measure

Treats the measure as an attribute and groups the result set by it.

cost by revenue
product by quantity purchased

When using the top or bottom keywords without specifying a number n, the number defaults to 10.

Date

Keyword Examples

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 year-over-year	`growth of revenue by order date daily year-over-year`
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`
n days for each month	`sales last 2 days for each month`
n days for each quarter	`revenue last 15 days for each quarter`
n days for each week	`total sold last 2 days for each week`
n days for each year	`revenue last 300 days for each year`
growth of … by … daily	`growth of sales by order date daily`
growth of … by … monthly	`growth of sales by order date monthly sales > 24000`
growth of … by … quarterly	`growth of sales by order date quarterly`
growth of … by … weekly	`growth of sales by receipt date weekly for pro-ski2000`
growth of … by … yearly	`growth of sales by receipt date closed yearly`
growth of … by …	`growth of sales by order date`
n hours for each day	`sales last 2 hours for each day`
last day by	`customers last day by referrer`
last month	`customers last month by store`
hourly	`visitors by page name hourly`
last month by	`customers last month by day`
last n days	`visitors last 7 days`
last n months	`visitors last 10 months` by day
last n quarters	`visitors last 2 quarters by month by campaign`
last n weeks	`visitors last 10 weeks by day`
last quarter	`customers last quarter sale > 300`
last week	`customers last week by store`
last year	`top 10 customers last year by sale by store for region west`
last n years	`visitors last 5 years by revenue for sum revenue > 5000`
month to date	`sales by product month to date sales > 2400`
month year	`commission by sales rep February 2014`
month	`commission January`
month	`revenue by month last year`
monthly year-over-year	`growth of revenue by receipt date monthly year-over-year`
monthly	`commission > 10000 monthly`
n months for each quarter	`cost last 2 months for each quarter`
n months for each year	`last 8 months for each year`
n days ago	`sales 2 days ago`
n months ago	`sales 2 months ago by region`
n months	`visitors last 6 months for homepage visits > 30 by month`
n quarters ago	`sales 4 quarters ago by product name contains deluxe`
n weeks ago	`sales 4 weeks ago by store`
n years ago	`sales 5 years ago by store for region west`
n years	`opportunities next 5 years by revenue`
next day	`shipments next day by order`
next month	`appointments next month by day`
next n days	`shipments next 7 days`
next n months	`openings next 6 months location`
next n quarters	`opportunities next 2 quarters by campaign`
next n weeks	`shipments next 10 weeks by day`
next n years	`projected deals next 5 years`
next quarter	`opportunities next quarter amount > 30000`
next week	`shipments next week by store`
next year	`opportunities next year by sales rep`
quarter to date	`sales by product quarter to date for top 10 products by sales`
quarterly year-over-year	`growth of revenue by date shipped quarterly year-over-year`
quarterly	`sales quarterly for each product`
n quarters for each year	`last 2 quarters for each year`
this day	`shipments this day by order`
this month	`appointments this month by day`
this quarter	`opportunities this quarter amount > 30000`
this week	`shipments this week by store`
this year	`opportunities this year by sales rep`
today	`sales today by store`
week to date	`sales by order date week to date for pro-ski200`
week	`revenue by week last quarter`
weekly year-over-year	`growth of revenue by date shipped weekly year-over-year`
weekly	`revenue weekly`
n weeks for each month	`sales last 3 weeks for each month`
n weeks for each quarter	`last 2 weeks for each quarter`
n weeks for each year	`last 3 weeks for each year`
year to date	`sales by product year to date`
year	`revenue by product 2014 product name contains snowboard`
yearly	`shipments by product yearly`
yesterday	`sales yesterday for pro-ski200 by store`

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 year-over-year

growth of revenue by order date daily year-over-year

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

n days for each month

sales last 2 days for each month

n days for each quarter

revenue last 15 days for each quarter

n days for each week

total sold last 2 days for each week

n days for each year

revenue last 300 days for each year

growth of … by … daily

growth of sales by order date daily

growth of … by … monthly

growth of sales by order date monthly sales > 24000

growth of … by … quarterly

growth of sales by order date quarterly

growth of … by … weekly

growth of sales by receipt date weekly for pro-ski2000

growth of … by … yearly

growth of sales by receipt date closed yearly

growth of … by …

growth of sales by order date

n hours for each day

sales last 2 hours for each day

last day by

customers last day by referrer

last month

customers last month by store

hourly

visitors by page name hourly

last month by

customers last month by day

last n days

visitors last 7 days

last n months

visitors last 10 months by day

last n quarters

visitors last 2 quarters by month by campaign

last n weeks

visitors last 10 weeks by day

last quarter

customers last quarter sale > 300

last week

customers last week by store

last year

top 10 customers last year by sale by store for region west

last n years

visitors last 5 years by revenue for sum revenue > 5000

month to date

sales by product month to date sales > 2400

month year

commission by sales rep February 2014

month

commission January

month

revenue by month last year

monthly year-over-year

growth of revenue by receipt date monthly year-over-year

monthly

commission > 10000 monthly

n months for each quarter

cost last 2 months for each quarter

n months for each year

last 8 months for each year

n days ago

sales 2 days ago

n months ago

sales 2 months ago by region

n months

visitors last 6 months for homepage visits > 30 by month

n quarters ago

sales 4 quarters ago by product name contains deluxe

n weeks ago

sales 4 weeks ago by store

n years ago

sales 5 years ago by store for region west

n years

opportunities next 5 years by revenue

next day

shipments next day by order

next month

appointments next month by day

next n days

shipments next 7 days

next n months

openings next 6 months location

next n quarters

opportunities next 2 quarters by campaign

next n weeks

shipments next 10 weeks by day

next n years

projected deals next 5 years

next quarter

opportunities next quarter amount > 30000

next week

shipments next week by store

next year

opportunities next year by sales rep

quarter to date

sales by product quarter to date for top 10 products by sales

quarterly year-over-year

growth of revenue by date shipped quarterly year-over-year

quarterly

sales quarterly for each product

n quarters for each year

last 2 quarters for each year

this day

shipments this day by order

this month

appointments this month by day

this quarter

opportunities this quarter amount > 30000

this week

shipments this week by store

this year

opportunities this year by sales rep

today

sales today by store

week to date

sales by order date week to date for pro-ski200

week

revenue by week last quarter

weekly year-over-year

growth of revenue by date shipped weekly year-over-year

weekly

revenue weekly

n weeks for each month

sales last 3 weeks for each month

n weeks for each quarter

last 2 weeks for each quarter

n weeks for each year

last 3 weeks for each year

year to date

sales by product year to date

year

revenue by product 2014 product name contains snowboard

yearly

shipments by product yearly

yesterday

sales yesterday for pro-ski200 by store

Time

Keyword Examples

Keyword	Examples
detailed	`ship time detailed`
last minute	`count homepage views last minute`
last hour	`count unique visits last hour`
n minutes	`count visitors last 30 minutes`
n hours	`count visitors last 12 hours`
n minutes ago	`sum inventory by product 10 minutes ago`
n hours ago	`sum inventory by product by store 2 hours ago`
next hour	`count projected visitors next hour`
next minute	`count projected visitors next minute`
this hour	`count visitors this hour`
this minute	`count visitors this minute`

detailed

ship time detailed

last minute

count homepage views last minute

last hour

count unique visits last hour

n minutes

count visitors last 30 minutes

n hours

count visitors last 12 hours

n minutes ago

sum inventory by product 10 minutes ago

n hours ago

sum inventory by product by store 2 hours ago

next hour

count projected visitors next hour

next minute

count projected visitors next minute

this hour

count visitors this hour

this minute

count visitors this minute

Text

Keyword Examples

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'`

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

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`

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

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 date != last 5 days`

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 date != last 5 days

Location

Keyword Examples

Keyword	Examples
near	`revenue store name county near san francisco`
near… within n miles\|km\|meters	`revenue store name county near alameda within 50 miles`
farther than n miles\|km\|meters from	`average hours worked branch farther than 80 km from scarborough`
Location keywords only work for searches where the data source includes latitude/longitude data. You can only use them if you bring your data into ThoughtSpot’s in-memory database. You cannot use these keywords if you connect to your data in an external database.

near

revenue store name county near san francisco

near… within n miles|km|meters

revenue store name county near alameda within 50 miles

farther than n miles|km|meters from

average hours worked branch farther than 80 km from scarborough

Location keywords only work for searches where the data source includes latitude/longitude data. You can only use them if you bring your data into ThoughtSpot’s in-memory database. You cannot use these keywords if you connect to your data in an external database.

Period

Keyword Example

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)`

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 / Not in

Keyword Description Example

Keyword	Description	Example
attribute in (attribute subsearch)	Query in query search (intersection of two sets). You must match the last attribute before the keyword with the first attribute inside the subsearch.	`store name in (top 10 store name by sales footwear)` `product name 2014 product name in (product name 2013) sales`
attribute not in (attribute subsearch)	Relative complement of two sets. You must match the last attribute before the keyword with the first attribute inside the subsearch.	`product name 2014 product name not in (product name 2013) sales` Find sales for all products ordered in 2014 that were not ordered in 2013

attribute in (attribute subsearch)

Query in query search (intersection of two sets). You must match the last attribute before the keyword with the first attribute inside the subsearch.

store name in (top 10 store name by sales footwear)
product name 2014 product name in (product name 2013) sales

attribute not in (attribute subsearch)

Relative complement of two sets. You must match the last attribute before the keyword with the first attribute inside the subsearch.

product name 2014 product name not in (product name 2013) sales

Find sales for all products ordered in 2014 that were not ordered in 2013

Starting with release 6.2, searches with the in keyword do not include {null} values. To include these {null} values, create a formula for the relevant attribute in your search, to convert {null} values to 'unknown,' or some similar word.

Was this page helpful?Give us feedback!

Keyword reference

Keywords in other languages

General

Date

Time

Text

Number

Comparative

Location

Period

In / Not in

Product

By Role

By Department

Solutions

About Us

Connect